I am running MySQL 5.5 replication environment and I need to change the password on the replication user. I have tried the following:
change passwords on master and slaves
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?