mysql remote connection

[richie]

Hello. I hope somebody can help me solve this one.

I need to connect remotely to a mysql server using:

mysql -u remoteuser -h x.x.x.x -p

Where x.x.x.x is the ip address of the remote mysql server.

On the remote server, I already issued the following grant commands:

grant all privileges on dbname.* to remoteuser@'localhost' identified by 'passwd'

grant all privileges on dbname.* to remoteuser@'%' identified by 'passwd'

The above two commands should allow a connection from anywhere.

Also, port 3306 is not blocked in the firewall.

But when I run the command below from a remote machine:

mysql -u remoteuser -h x.x.x.x -p

I get the error:
ERROR 2003: Can't connect to MySQL server on 'x.x.x.x' (113)

What have I missed?

Server version: 4.1.19

[examancer]

At least just looking at the error, you may also need to open port 113. Generally thats used for authentication and identd, so I would assume thats what mysql needs it for. Don't have much remote mysql experience though so can't guarantee thats the problem.

[richie]

examancer, you made my day. Worked like a charm!

Thanks a lot.

[examancer]

just a lucky guess 😃