Re: Unable to grant replication slave/client to class c

[Dominik Klein]

Michael M. schrieb:

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'm not sure if this is correct syntax.
Use the specific IP address instead and execute
show grants for repl@ip

Do this for both machines in your multimaster setup (replace the ip of 
course)



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. 


I set up such a system and wrote a little howto on that in the LVS 
documentation:

http://www.austintek.com/LVS/LVS-HOWTO/HOWTO/LVS-HOWTO.failover.html#ha_mysql

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Unable to grant replication slave/client to class c

[Michael M.]

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