MySQL Workbench Connection Error

[lloydcodrington]

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....

Thanks in anticipation,
Lloyd

[falko]

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]

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]

Originally Posted by lloydcodrington

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:

dig -x 1.2.3.4

Replace 1.2.3.4 with your public IP.)