I've set up a MySQL replication server, but when I run "slave start;", I got this error on the slave side. It displays:
Code:
waiting to reconnect after a failed master event read
when I raise "show slave status", And in the error log of the slave computer, it shows:
Code:
100309 12:09:57 [ERROR] Error reading packet from server: Access denied; you need the REPLICATION SLAVE privilege for this operation ( server_errno=1227)
Luckily it's fixed soon by this command:
Code:
GRANT REPLICATION SLAVE TO replicator@'%';