I'm attempting to take a brand new mysql server build on gentoo and set up replication.
I'm using GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@"192.168.1.0/255.255.255.0" IDENTIFIED BY 'secret'; I've tried various combinations of removing the quotes, tried not using a password, and various other things, yet when I SHOW GRANTS FOR repl; I get nothing. If I do the same, and use % for all hosts, it works, and it shows up in the grants. I tried to limit it to one IP, it wouldn't show up, tried %.domain.com and that wouldn't work either. The only way I could get anything at all to show up when SHOW GRANTS FOR repl; was performed is to use GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@"%" IDENTIFIED BY 'secret'; Now, what I'll eventually be setting up is a master-master replication (basically only for failover using keepalived), so if anyone has any experience with that, I'd be much appreciated. These are completely empty freshly built gentoo/mysql installs, so a "from the ground up" reply is appreciated. Thanks, Michael