Ray Kootstra Ray Kootstra - 11 months ago
585 0

Steps to change mysql replication user password.

MySQL

Change MySQL replication password

1. SLAVE STOP;
2. SET SQL_LOG_BIN=0;
3. # at this point change the password for the replicant user on the master and slave
4. CHANGE MASTER TO MASTER_PASSWORD=‘mynewpassword’; 
5. SLAVE START; 
6. Check status on slave with: SHOW SLAVE STATUS\G;