Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
None
Description
replication failed with 1290 in the slave database after changing a user password in the master database.
In Master:
MariaDB [(none)]> set password for test=PASSWORD('St_3t_357'); |
Query OK, 0 rows affected (0.00 sec) |
In Slave, the replication failed with error 1290. But after set "global strict_password_validation" flag off and restarted the slave, the replication continued.
MariaDB [(none)]> show slave status \G
|
*************************** 1. row ***************************
|
Slave_IO_State: Waiting for master to send event |
Master_Host: zlt11336.vci.att.com
|
Master_User: rep_user
|
Master_Port: 3306
|
Connect_Retry: 10
|
Master_Log_File: mysql-bin.000637
|
Read_Master_Log_Pos: 16958
|
Relay_Log_File: zlt11337-relay-bin.000003
|
Relay_Log_Pos: 780
|
Relay_Master_Log_File: mysql-bin.000637
|
Slave_IO_Running: Yes
|
Slave_SQL_Running: No |
Replicate_Do_DB:
|
Replicate_Ignore_DB:
|
Replicate_Do_Table:
|
Replicate_Ignore_Table:
|
Replicate_Wild_Do_Table:
|
Replicate_Wild_Ignore_Table:
|
Last_Errno: 1290
|
Last_Error: Error 'The MariaDB server is running with the --strict-password-validation option so it cannot execute this statement' on query. Default database: ''. Query: 'SET PASSWORD FOR 'test'@'%'='*8CA4AFBD5B1FAB0AC14A455288A94764E4AF46BD'' |
Skip_Counter: 0
|
Exec_Master_Log_Pos: 16785
|
Relay_Log_Space: 5084
|
Until_Condition: None
|
Until_Log_File:
|
Until_Log_Pos: 0
|
Master_SSL_Allowed: No |
Master_SSL_CA_File:
|
Master_SSL_CA_Path:
|
Master_SSL_Cert:
|
Master_SSL_Cipher:
|
Master_SSL_Key:
|
Seconds_Behind_Master: NULL |
Master_SSL_Verify_Server_Cert: No |
Last_IO_Errno: 0
|
Last_IO_Error:
|
Last_SQL_Errno: 1290
|
Last_SQL_Error: Error 'The MariaDB server is running with the --strict-password-validation option so it cannot execute this statement' on query. Default database: ''. Query: 'SET PASSWORD FOR 'test'@'%'='*8CA4AFBD5B1FAB0AC14A455288A94764E4AF46BD'' |
Replicate_Ignore_Server_Ids:
|
Master_Server_Id: 1
|
Master_SSL_Crl:
|
Master_SSL_Crlpath:
|
Using_Gtid: Slave_Pos
|
Gtid_IO_Pos: 0-1-1871366
|
Replicate_Do_Domain_Ids:
|
Replicate_Ignore_Domain_Ids:
|
Parallel_Mode: conservative
|
1 row in set (0.00 sec) |
|
|
MariaDB [(none)]>
|
MariaDB [(none)]> set global strict_password_validation = off; |
Query OK, 0 rows affected (0.00 sec) |
|
|
MariaDB [(none)]> stop slave;
|
Query OK, 0 rows affected (0.00 sec) |
|
|
MariaDB [(none)]> start slave;
|
Query OK, 0 rows affected (0.01 sec) |
|
|
MariaDB [(none)]> show slave status \G
|
*************************** 1. row ***************************
|
Slave_IO_State: Waiting for master to send event |
Master_Host: zlt11336.vci.att.com
|
Master_User: rep_user
|
Master_Port: 3306
|
Connect_Retry: 10
|
Master_Log_File: mysql-bin.000637
|
Read_Master_Log_Pos: 16958
|
Relay_Log_File: zlt11337-relay-bin.000002
|
Relay_Log_Pos: 866
|
Relay_Master_Log_File: mysql-bin.000637
|
Slave_IO_Running: Yes
|
Slave_SQL_Running: Yes
|
Replicate_Do_DB:
|
Replicate_Ignore_DB:
|
Replicate_Do_Table:
|
Replicate_Ignore_Table:
|
Replicate_Wild_Do_Table:
|
Replicate_Wild_Ignore_Table:
|
Last_Errno: 0
|
Last_Error:
|
Skip_Counter: 0
|
Exec_Master_Log_Pos: 16958
|
Relay_Log_Space: 1167
|
Until_Condition: None
|
Until_Log_File:
|
Until_Log_Pos: 0
|
Master_SSL_Allowed: No |
Master_SSL_CA_File:
|
Master_SSL_CA_Path:
|
Master_SSL_Cert:
|
Master_SSL_Cipher:
|
Master_SSL_Key:
|
Seconds_Behind_Master: 0
|
Master_SSL_Verify_Server_Cert: No |
Last_IO_Errno: 0
|
Last_IO_Error:
|
Last_SQL_Errno: 0
|
Last_SQL_Error:
|
Replicate_Ignore_Server_Ids:
|
Master_Server_Id: 1
|
Master_SSL_Crl:
|
Master_SSL_Crlpath:
|
Using_Gtid: Slave_Pos
|
Gtid_IO_Pos: 0-1-1871366
|
Replicate_Do_Domain_Ids:
|
Replicate_Ignore_Domain_Ids:
|
Parallel_Mode: conservative
|
1 row in set (0.00 sec) |
|
|
MariaDB [(none)]>
|