<div>
Hi Arnold and Idvhai, &nbsp;Thank you both very much. &nbsp;That seems to have worked a treat and I had forgotten all about flush privileges. &nbsp;Case closed and I will award as many points as possible to both of you. &nbsp;Thanks again, &nbsp;Bede
</div>


Hi Arnold and Idvhai,  Thank you both very much.  That seems to have worked a treat and I had forgotten all about flush privileges.  Case closed and I will award as many points as possible to both of you.  Thanks again,  Bede

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I am running MySQL 5.5 replication environment and I need to change the password on the replication user. &nbsp;I have tried the following:<br />
<br />
stop slave<br />
change passwords on master and slaves<br />
start slave<br />
<br />
I then get an error connecting to master when I run 'show slave status'. &nbsp;If I repeat the process setting the password back to the original one, then replication all starts again perfectly. &nbsp;What have I missed.<br />
<br />
As a secondary question, which order should I update versions of MySQL. &nbsp;Master then slaves or the other way round?<br />
<br />
Many thanks<br />
<br />
Bede
</div>
</div>


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

Problem when changing replication user password

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.