29 January 2011

MySQL - grant slave permitions

grant replication slave on *.* to user1@192.168.0.1 identified by '123456';
grant replication client on *.* to user1@192.168.0.1;
grant super,reload,select on *.* to user1@192.168.0.1;

P.S. Off course you have to enable the binary log on the master server...

No comments:

Post a Comment