MySQL Replication problems
Hullo :)
I'm using mysql-server 4.0.24, mostly from backports.org whose packages I
trust :)
One test setup of single-slave replication worked perfectly, but on another
server, I am constantly told
Mar 18 14:33:35 liz mysqld[10179]: 050318 14:33:35 Slave I/O thread: connected
to master 'repl@meg:3306', replication started in log 'mysql-bin.001' at
position1309
Mar 18 14:33:35 liz mysqld[10179]: 050318 14:33:35 While trying to obtain the
list of slaves from the master 'meg:3306', user 'repl' got the following
error: 'Access denied. You need the REPLICATION SLAVE privilege for this
operation'
The 'repl' in question on 'meg' is:
mysql> select * from user where User = 'repl' \G
*************************** 1. row ***************************
Host: liz.nation-net.com
User: repl
Password: 4415ccf84a329c7c
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Repl_slave_priv: Y
Repl_client_priv: N
Super_priv: N
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
1 row in set (0.00 sec)
mysql_fix_privilege_tables has been run on all servers.
I have restarted the meg mysql-server as well as the usual flush
hosts/privileges... can anyone suggest any reason why this wouldn't be
working when Repl_slave_priv is clearly set to Y? On the working setup, the
repl user has only the Repl_slave_priv Y - everything else is N.
It's not DNS because if I run 'host' on the source IP of liz (verified the
source IP using tcpdump) it comes back with 'liz.nation-net.com'
Any advice warmly welcomed - this has really puzzled me!
Cheers,
Gavin.
Reply to: