MySQL Server Problem

[athomas]

Ok, one of my many linux servers will not allow SQL connections from the outside. I've created another full access user, it gives a 2003 connect error. This only happens on a remote machine. I am trying to connect with MySQL administrator. I am having this issue both within the same subnet, and on an outside network, with the port open, and connecting on port 3306. Telnet does not work within the network or outside.

[Paul]

You have to make sure that the IP address you are connecting from has permission to access the database. If by any chance you have cPanel this can be found under databases and then hostslist. If you don't have cPanel you can do it through the command line:

http://help.hardhathosting.com/question.php/87

[Vege]

if it's a socket connection (as most mysql servers usually are if they are used out of the box), best solution would be tunnel some port of yours to that server port 3306
So you would be connecting to 127.0.0.1 even thou you are connecting to that remote server.

Socket connections can't be accessed from remote servers, but this thing can be changed from my.cnf in folder where mysql configuration file reside.

[athomas]

Well my.cnf looks ok, it's set to the internal IP, ports are forwarded (which wouldnt make a difference in the network)

[Vege]

Are you connecting to "localhost" or to 127.0.0.1 as those are different atleast to mysqlQueryBrowser.

[athomas]

Like I said already... locally works fine, inside or outside the network from another machine does not.

[Vege]

Usually tunnels are connected trough localhost, meaning as I asked were you using a tunnel I tought that you had your 3306 port tunneled to the local host so connecting to localhost would actually connect to the localhost of the remote host. Are you familiar with tunneling in general?

I'm just suggesting it as it seems the easies way if you can allready connect to it from local host of the remote host.

Ssh -L 6666:localhost:3306 user@remoteserver.com would be the Linux command.

Reason I might sound stupid is that I start with the basics as I don't know your 'level'