MySQL Workbench Connection Error

Discussion in 'Server Operation' started by lloydcodrington, Feb 2, 2011.

  1. lloydcodrington

    lloydcodrington New Member

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

    falko Super Moderator ISPConfig Developer

    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?
     
  3. lloydcodrington

    lloydcodrington New Member

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

    falko Super Moderator ISPConfig Developer

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

Share This Page