Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TheMaster|mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'$slaveip' IDENTIFIED BY '$slavepass';
- TheMaster|mysql> FLUSH PRIVILEGES;
- TheSlave$ mysql --host=TheMaster --user=repl --password=$slavepass
- TheSlave|mysql> SHOW GRANTS;
- +------------------------------------------------------------+
- | Grants for repl@$slaveip |
- +------------------------------------------------------------+
- | GRANT REPLICATION SLAVE ON *.* TO 'repl'@'$slaveip' |
- +------------------------------------------------------------+
- 1 row in set (0.01 sec)
- server_id = 2
- TheSlave|mysql> CHANGE MASTER TO
- MASTER_HOST='$masterip',
- MASTER_USER='repl',
- MASTER_PASSWORD='$slavepass',
- MASTER_LOG_FILE='TheMaster-bin.000001',
- MASTER_LOG_POS=481;
- TheSlave|mysql> START SLAVE;
- TheSlave|mysql> SHOW SLAVE STATUS G
- ...
- Slave_IO_Running: Yes
- Slave_SQL_Running: Yes
- ...
- Seconds_Behind_Master: 13
- ...
- 2016-04-20T18:11:34.896095Z 20955 [Note] Access denied for user 'root'@'localhost' (using password: NO)
- 2016-04-20T18:11:34.896580Z 20956 [Note] Access denied for user 'root'@'localhost' (using password: NO)
- 2016-04-20T18:11:34.896982Z 20957 [Note] Access denied for user 'root'@'localhost' (using password: NO)
- 2016-04-20T18:11:34.897401Z 20958 [Note] Access denied for user 'root'@'localhost' (using password: NO)
- 2016-04-20T18:11:34.901181Z 20959 [Note] Access denied for user 'root'@'localhost' (using password: NO)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement