MySQL replication: waiting for reconnection after failed registration on the server

Question

I have two MySQL servers in the master-master-setup. The setup is exactly the same (following the process I wrote last time), but does not work properly.

I get messages:

Slave_IO_State: Waiting to reconnect after a failed registration on master

Slave has read all relay log; waiting for the slave I/O thread to update it

Slave_IO_Running: Connecting

I re-created the replication user several times to no avail. If I use another user (in this case, an administrator with all privileges), everything will work fine.

I cannot find the reason why the username will affect the connection.

Any ideas?

Answer 1

, , , , .

mysql> CREATE USER 'repl'@'%.mydomain.com' IDENTIFIED BY 'slavepass';
mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com';

!