Home / server / Questions / 687027
Accepted
Ernie
Asked: 2015-05-02 10:27:23 +0800 CST

MySQL not allowing remote connections from new server

  • 772

I currently have one server that's connecting to a centralized MySQL server (say, 192.168.0.10). This server already allows remote connections from this IP address (say, 192.168.0.20), and in spite of my changes so far, continues to work. For this one IP address.

When I try to grant access to this same username and password from different hosts like this:

update db set host='192.168.0.%' where user='username';
update user set host='192.168.0.%' where user='username';
flush privileges;

Everything still stays the same. I can still connect from 192.168.0.20, but I also still can't connect from 192.168.0.25. I get the error message

ERROR 1130 (HY000): Host '192.168.0.25' is not allowed to connect to this MySQL server

I can't see how this is wrong. All the documentation says it should work. I'm also not firewalling connections from 192.168.0.25. Even restarting MySQL has no effect. Other IPs on this network can connect to MySQL without any issue - even ones that were previously not allowed - and I can ping 192.168.0.10 from 192.168.0.25.

mysql

1 Answers

  1. Best Answer

    You have to modify mysql.user table, not only the mysql.db.

    The proper syntax is:

    RENAME USER 'user'@'192.168.0.10' TO 'user'@'192.168.0.%';
FLUSH PRIVILEGES;
    • 3