Unable to grant replication slave/client to class c

Michael M. · *nix forums beginner Joined: 12 Feb 2006 Posts: 41

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

Google