Setting up MySQL Workbench connection

 
Post new topic   Reply to topic    34SP.com Forum Index // Database Support
View previous topic :: View next topic  
Author Message
madconker
34SP Newbie
34SP Newbie


Joined: 20 Feb 2005
Posts: 14
Location: Windsor

PostPosted: Tue Nov 09, 2010 10:15 am    Post subject: Setting up MySQL Workbench connection Reply with quote
I am trying to create a new connection from MySQL Workbench to my hosted database.

Let's assume the details of my database on my 34sp account are:

Domain name: mycompany.co.uk
Database Name: database
User Name: user
Password: password

In MySQL Workbench I fill out the following properties to connect:

Hostname: mycompany.co.uk
Port: 3306
Username: user
Password: password
Default Schema:

I'm not sure what the default schema should be, maybe my database name?

When I try to connect I receive an "error 10060"

It's not asking what the database name is which I also find strange.

If you know how to connect from MySQL Workbench then please let me know,

Cheers
Back to top
View user's profile Send private message Visit poster's website
imknight
Administrator
Administrator


Joined: 16 Mar 2001
Posts: 3627
Location: Stroud,Gloucestershire

PostPosted: Thu Nov 11, 2010 3:18 pm    Post subject: Reply with quote
I use heidisql for remote connections - this will work fine with the details you have listed above.
_________________
Ian
34SP.com
Easy script installers for a small number of popular scripts are now available at http://scripts.34sp.com
Used our script installers? Please post your site here

| Wordpress Hosting |
Back to top
View user's profile Send private message Send e-mail Visit poster's website ICQ Number
madconker
34SP Newbie
34SP Newbie


Joined: 20 Feb 2005
Posts: 14
Location: Windsor

PostPosted: Thu Nov 11, 2010 6:24 pm    Post subject: Reply with quote
Hi,

I got the same error with HeidiSQL as well, so lead me to believe it is because of my companies firewall.

I've now tested the connection from my home computer and it works fine! Sorry about that.

So I can see my schema that I've created, but I also can see another schema called "test".

Is this standard with 34sp.com MySQL databases?
Back to top
View user's profile Send private message Visit poster's website
peterwt
34SP User


Joined: 22 Mar 2001
Posts: 230
Location: South Wales

PostPosted: Fri Nov 12, 2010 5:53 pm    Post subject: Reply with quote
madconker wrote:

So I can see my schema that I've created, but I also can see another schema called "test".



Just started using HeidiSQL (was using MySqlFront but could not get it to work on my newPC ) and I see test as well, but it is empty.
_________________
Peter
Back to top
View user's profile Send private message Send e-mail Visit poster's website
imknight
Administrator
Administrator


Joined: 16 Mar 2001
Posts: 3627
Location: Stroud,Gloucestershire

PostPosted: Mon Nov 15, 2010 10:53 am    Post subject: Reply with quote
"test" is a standard mysql database setup with full access to anyone, no-one should use this as a database name as anyone and everyone can add/delete/remove etc anything in this databse name. Its part of the standard mysql setup.
_________________
Ian
34SP.com
Easy script installers for a small number of popular scripts are now available at http://scripts.34sp.com
Used our script installers? Please post your site here

| Wordpress Hosting |
Back to top
View user's profile Send private message Send e-mail Visit poster's website ICQ Number
madconker
34SP Newbie
34SP Newbie


Joined: 20 Feb 2005
Posts: 14
Location: Windsor

PostPosted: Thu Dec 23, 2010 10:46 am    Post subject: Reply with quote
Thanks for your help, and Merry Xmas!
Back to top
View user's profile Send private message Visit poster's website
Post new topic   Reply to topic    34SP.com Forum Index // Database Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Powered by phpBB © 2001, 2002 phpBB Group