Mysql – One MySQL user from 2 hosts not on same subnet

MySQLpermissions

I've googled around for this with no luck. I have a master database with one slave. The perms for the slave are set and it runs fine. I'd like to add another slave using a clone of the original server. So far, everything is fine except my slave user is only granted access from one host: 10.10.10.10 . The second slave I'd like to bring up has the IP address 10.10.10.20 and I can't allow access across the entire subnet ( I also can't change the internal IP addresses).

So, I'd like to update the hosts the slaves can access the master to both IP addresses and can seem to figure out how.

Any help is greatly appreciated.

Best Answer

Look at the mysql:user table The user is likely enabled only from one host (by name or IP). You can do one of two things:

  • Add a second occurrence of the user with access from the second host. (Most secure.)
  • Change the host criteria to be less restrictive. (Less secure.)

See the MySQL Access Restrictions documentation for possible less restrictive host specifications.

Related Question