Mysql – Can not connect to MySql server remotely

MySQL

I can not connect to MySQL server from a remote computer. When I try to connect it gives me the error

Host '' is not allowed to connect to this MySQL server

I've edited the MySQL server my.ini file by changing the bind line from #bind = "127.0.0.1" to bind = *. I've turned off the firewall of the client machine trying to access the server. I also gave full privilege to the user of MySQL database through which I am trying to connect to the server by using the MySQL grant command, but nothing seems to be working.

Please help me.

Thanks

Best Answer

A MySQL user has a "from host" field. This is probably set to some IP and those mismatch, giving you that error. This field allows for extra security and can be set to any IP/hostname. If this field is set for the user then you can only login to the MySQL server with that user from the IP/hostname specified. If you want to test your connection you can just use a wildcard for the "from host" field % so that any IP can connect using that user, I wouldn't recommend this in a product environment though.

Related Solutions

Mysql – Connection to MySQL Remotely

You state that "Connections, ports, user accounts and credentials are all fine.", but I have my doubts.

Mentioning the exact error from the documentation:

[The error] occurs when you try to connect from a host other than the one on which the MySQL server is running, it means that there is no row in the user table with a Host value that matches the client host

Look in your mysql.user table on the Linux MySQL server for a user entry with the user/host combination of your windows machine:

SELECT User, Host FROM mysql.user WHERE User='my_user' AND Host='windows_ip';

If that doesn't return a result, you'll need to add that user. If it does return a result, can you add that to your question?

Mysql – force thesql server to resolve the external ip to localhost

Great, here is the solution I found. I'm chosing to post it here instead of just removing the question since I believe it may be relevant for further reference.

Basically the idea is to leave mysql alone but to tell the server to resolve the ip. In the case of my centos6 configuration it means editing the /etc/hosts file and appending a my.servers.ip.address localhost line into it.

Hope it helped! S.

Best Answer

Related Solutions

Mysql – Connection to MySQL Remotely

Mysql – force thesql server to resolve the external ip to localhost

Related Question