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