HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)

- Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)

- - MySQL Workbench Connection Error (http://www.howtoforge.com/forums/showthread.php?t=51223)

lloydcodrington

2nd February 2011 00:11

MySQL Workbench Connection Error

Hi Guys,
I have a centOS local testing server which I installed with the aid of one of the guides on this site. It has been working fine and I am able to access all my test sites and databases via Dreamweaver ftp and SSH etc. Also I am able to access mysql using phpmyadmin.

However I now need the power of MySQL Workbench to work on a project and am having difficulty connecting to the database. I keep getting an error: Can't connect to MySQL server on (10060).

Can anyone suggest a way forward as I am running out of hair....:mad:

Thanks in anticipation,
Lloyd

falko

2nd February 2011 15:25

Did you install MySQL Workbench on your Windows desktop? If so, does your MySQLserver allow remote connections? Is port 3306 open in the server's firewall?

lloydcodrington

2nd February 2011 16:48

Hi falko,
Yes I do have the port open but I was wondering if there was something I needed to set in the config file as I do know that on my production server which I manage via WebHostManager, WHM, I have to specify a host for it to be allowed remote access to MySQL itself. But am not sure what and where the changes are stored when done via WHM.

falko

3rd February 2011 13:40

Quote:

Originally Posted by lloydcodrington (Post 250165)

I have to specify a host for it to be allowed remote access to MySQL itself.

Can you use a wildcard? Otherwise you must use your desktop PC's public IP (or the hostname that is associated to that IP; you can look it up as follows:

Code:

dig -x 1.2.3.4

Replace 1.2.3.4 with your public IP.)

All times are GMT +2. The time now is 11:46.