Hi Everyone,

I am running Fedora Core 4 with MySQL 4.1.5

I am trying to connect to MySQL from a remote server and am having problems.

Specifically:
If try to > telnet x.x.x.x 3306
I get a "M#HY000Host 'y.y.y.y' is not allowed to connect to this MySQL server Connection closed by foreign host." error.

I can succesfully > telnet localhost 3306 < from the localhost
and I can succesfully > telnet x.x.x.x 3306 < from the localhost

I have checked that I do not have anything like a --skip_networking statement anywhere, and would assume that since it is MySQL that is actually refusing the connection that my firewall is working correctly

I do not believe that the problem is caused by incorrect user permissions as I never get asked to login - I get rejected as soon as I attempt to connect to the server.

Any assistance would be much appreciated.

Regards,
James.

Hi,
MySQL can be configured to restrict remote access by IP address as well as username. user@localhost is not the same as user@<some-other-ip-addr>.

Details are in the MySQL manual at:
http://dev.mysql.com/doc/refman/4.1/...on-access.html

Regards,
Jimvin

Hi,

Thanks for your help - problem is now solved.

What I have discovered is that:

1. At the very least, one MySQL user must have rights to log into the MySQL server from the remote client before the MySQL server will let anyone attempt to login from the remote client.

2. It is important to use the SQL "Grant..." command to provide the MySQL user with the right to login from the remote host. Simply changing the host field of an existing user to the name of the remote client is not sufficient.

Regards,
James.