Connect to mysql database from external server

[albyh]

Hi,

Im trying to set up a server purely for MySQL use. The problem I have is I can connect to the database from Localhost but not from any other servers. I have got both localhost and % users in my users table.

Any help would be greatly appreciated.

Thanks

Alby

 

[guelphdad]

when you write your connection do you remember to specify host?

mysql -ujimmyhoffa -p***** -h123.45.67.108

for instance?

 

[albyh]

Yeah the message I get is

ERROR 2003: Can't connect to MySQL server on '217.160.220.247'

Its as if theres a setting thats preventing remote connections.

 

[strucnjak79]

First plz give us more info like win or linux server, how do you want to connect...

If you have % user (and you said you have) check your firewall settings (if you have one)!

 

[albyh]

Its a linux server with 1 and 1. I just want to use it purely as a MySQL server. Ive set up phpMyAdmin on the server and all that works fine. The server isnt firewalled in any way.

Im actually trying to set up PHP Nuke another server so I just entered the host name as the MySQL servers IP address.

Ive also tried to connect from my other server using
mysql -u townsend -p -h 217.160.220.247.

Thanks

 

[strucnjak79]

I had same problem, and it was firewall 90%(I touch so many things, and when I finnaly connect I wasn't 100% shure what was the problem! It didn't help when I completly uninstall it, but when I allow port 3306 to be opened it was OK!