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 Theuser
is likely enabled only from onehost
(by name or IP). You can do one of two things:See the MySQL Access Restrictions documentation for possible less restrictive host specifications.