Home / server / Questions / 59874
In Process
staticsan
Asked: 2009-08-28 23:07:29 +0800 CST

MySQL Query Browser mysteriously can't connect

  • 772

I have a problem with an end-user who can't connect to their MySQL Server.

The facts:

  • Client is Windows XP on a corporate Domain. Group policy has disabled Windows Firewall and there is no other firewalling software installed.
  • The software MySQL's own query browser, v1.1.20, and is a permitted install.
  • The username and password are correct.
  • The query browser takes longer than a normal connect when trying then returns the error message "MySQL Error Number 2003 - Can't connect to MySQL Server on 'hostname' (10060)"
  • The query browser can "ping" the server with no problem.
  • Manually connecting using Window's own telnet command succeeds and the handshake initiation is clearly visible. So the hostname resolves on that PC and there is no networking issue (e.g. routing).
  • We've tried re-installing the query browser to no avail.
  • The server is running fine and everyone else who needs to connect (including myself) can successfully connect, most of them using the exact same version. So it is not a server problem.

Googling the error shows this is a classic unavailable connection problem and lots of links show fixes for the server, but the problem seems to reside entirely in the install of the query browser, which doesn't make any sense. Thus Google is no help.

Has anyone else seen this or can offer suggestions?

windows

5 Answers

  1. This may not be applicable to the OP, as their client is running on a windows XP corporate domain, but I had similar issues under OSX/Unix, encountering 2003 errors when the SSH tunnel was clearly configured correctly. Turned out it was an idiosyncrasy of the MySQL Query Browser:

    Note that in *nix OSs (including Mac OS X) you must use 127.0.0.1 rather than ‘localhost’ or the connection will be made via a named pipe rather than TCP. Source

    I'd always thought they were completely synonymous. Once I'd made the adjustment all worked as expected - hope this helps someone.

    • 2

  2. I can't answer your question but can say I have had the same experience once before an a Win XP machine. In that instance it Query Browser wouldn't connect to MySQL server on any machine, including a local instance. As a result, I now use a third party product called MySQL-Front. It's not free, but for me at least it was well worth the price.

    • 1

  3. I may have found a solution to this problem. When connecting to the MySQL server, do not save the credentials and information in MySQL Query Browser. Instead, retype them each time when signing in. This works for me for every computer in the domain.

    • 0

  4. There can be so many reasons why this problem occurs, so I'll try to contribute with a few suggested solutions based on the information you provided. Remember that these suggestions are shots in the dark, since there is absolutely no way to diagnostic this problem without having access to the server. With that said I'll start listing:

    • Check that the line skip_networking is not set to ON in the config file. If it is try to comment out this line.

    • You could also check that bind-address = 127.0.0.1 is not set in the config file. This line prevents everyone except localhost to connect to the database and you don't want that.

    • A third suggestion is that you could try to connect with a local account instead of a domain account. Windows Server don't allow domain accounts to use port 3306.

    • Check that the user has the privileges required to connect to the server from an external ip-address. You could try the following (or something similar):

    GRANT ALL ON database.* TO username@'client ip address' IDENTIFIED BY 'password';

    Remember to restart the mysql daemon each time you alter the configuration file. This error message is a little misleading, so I this helps you!

    • -1

  5. If you use Windows XP, then go to network adapter properties, uninstall "Microsoft TCP/IP version 6", restart your computer.

    • -2