Bug #2576 Changing User Password on Master breaks Replication
Submitted: 30 Jan 2004 2:32 Modified: 30 Jan 2004 4:59
Reporter: Stephan Amann Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:4.0.11-gamma-standard OS:SunOS 5.9
Assigned to: CPU Architecture:Any

[30 Jan 2004 2:32] Stephan Amann
Description:
We are running one master and one replica on different machines.

Both master and replica are the same mySQL Release on the same OS. We use 
phpmyadmin 2.4.0 for administartion and brwosing the mySQL DB.

After a 

  SET PASSWORD FOR "user"@"xxx.xxx.xxx.%"="encrypted password"

(Taken from the error log and changed the actual values for the bug report)

(which is executed by the phpmyadmin web interface), the master changes the password, but the replica fails to do so:

(From the Error Log of the Slave):

040130 10:49:38  Slave: error 'Can't find any matching row in the user table' on query 'SET PASSWORD FOR "user"@"xxx.xxx.xxx.%"="encrypted password"', error_code=1133
040130 10:49:38  Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'appl02-bin.305' position 2722379

How to repeat:
Change the password of a user (directly by SQL or by using phpmyadmin) on the master. Check the error log of the replica.
[30 Jan 2004 4:59] Alexander Keremidarski
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Replication of Privileges behaviour including SET PASSWORD was changed in 4.0.13, 4.0.14 and 4.0.15 to fix problems like this one