MySQL Forums
Forum List  »  Replication

Master replicating "Grant replication" statement to slave..?
Posted by: shahid hussain
Date: February 19, 2014 06:35AM

Hi ,
I m using mysql 5.6.16 version with gtid based replication. In master i have created an account for slave as below
GRANT REPLICATION SLAVE ON *.* TO 'johny'@'192.168.1.101' IDENTIFIED BY 'johny';
and at slave server i have executed change master as below
change master to master_host='192.168.1.100',master_port=3306,master_user='johny',master_password='johny',master_autoo_position=1;

My doubt is when i start slave it read all event from master including "GRANT REPLICATION......." which i had executed at master. And slave executed same query at his server. means slave also has executed below statement
GRANT REPLICATION SLAVE ON *.* TO 'johny'@'192.168.1.101' IDENTIFIED BY 'johny';

will execution of this statement affect slave?and there is no use of replicating this statement to slave as it was used to create slave account



Edited 1 time(s). Last edit at 02/19/2014 06:37AM by shahid hussain.

Options: ReplyQuote


Subject
Views
Written By
Posted
Master replicating "Grant replication" statement to slave..?
1690
February 19, 2014 06:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.