Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.18, 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
I found that ALTER USER failed to replicate on slave(s).
To reproduce this problem, I tried to change password on master server.
master [localhost] {msandbox} ((none)) > ALTER USER 'msandbox'@'localhost' IDENTIFIED BY 'msandbox1';
|
Query OK, 0 rows affected (0.00 sec)
|
 |
master [localhost] {msandbox} ((none)) > show grants for 'msandbox'@'localhost';
|
+--------------------------------------------------------------------------------------------------------------------------+
|
| Grants for msandbox@localhost |
|
+--------------------------------------------------------------------------------------------------------------------------+
|
| GRANT ALL PRIVILEGES ON *.* TO 'msandbox'@'localhost' IDENTIFIED BY PASSWORD '*E4042948BD58ED92656A17F1F5ADE60136095E6B' |
|
+--------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
Now, on slave password didn't changed. Check password hash between master and slave.
slave1 [localhost] {msandbox} ((none)) > show grants for 'msandbox'@'localhost';
|
+--------------------------------------------------------------------------------------------------------------------------+
|
| Grants for msandbox@localhost |
|
+--------------------------------------------------------------------------------------------------------------------------+
|
| GRANT ALL PRIVILEGES ON *.* TO 'msandbox'@'localhost' IDENTIFIED BY PASSWORD '*6C387FC3893DBA1E3BA155E74754DA6682D04747' |
|
+--------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
I also verified from master binary log that ALTER USER .. is not written into binary log.
Attachments
Issue Links
- duplicates
-
MDEV-19483 ALTER USER ... REQUIRE SSL is not replicated to slave
- Closed