Dear Experts,
I am running MySQL 5.5 replication environment and I need to change the password on the replication user. I have tried the following:
stop slave
change passwords on master and slaves
start slave
I then get an error connecting to master when I run 'show slave status'. If I repeat the process setting the password back to the original one, then replication all starts again perfectly. What have I missed.
As a secondary question, which order should I update versions of MySQL. Master then slaves or the other way round?
Many thanks
Bede
Our community of experts have been thoroughly vetted for their expertise and industry experience.