mirror of
https://github.com/MariaDB/server.git
synced 2025-02-10 15:35:34 +01:00
1e6210161d
post-merge changes: * handle password expiration on old tables like everything else - make changes in memory, even if they cannot be done on disk * merge "debug" tests with non-debug tests, they don't use dbug anyway * only run rpl password expiration in MIXED mode, it doesn't replicate anything, so no need to repeat it thrice * restore update_user_table_password() prototype, it should not change ACL_USER, this is done in acl_user_update() * don't parse json twice in get_password_lifetime and get_password_expired * remove LEX_USER::is_changing_password, see if there was any auth instead * avoid overflow in expiration calculations * don't initialize Account_options in the constructor, it's bzero-ed later * don't create ulong sysvars - they're not portable, prefer uint or ulonglong * misc simplifications
28 lines
772 B
Text
28 lines
772 B
Text
include/master-slave.inc
|
|
[connection master]
|
|
connection slave;
|
|
include/stop_slave.inc
|
|
connection master;
|
|
create user 'repl_user' password expire;
|
|
grant replication slave on *.* to repl_user;
|
|
flush privileges;
|
|
set global disconnect_on_expired_password=ON;
|
|
connection slave;
|
|
CHANGE MASTER TO MASTER_USER= 'repl_user';
|
|
START SLAVE;
|
|
include/wait_for_slave_io_error.inc [errno=1862]
|
|
include/stop_slave_sql.inc
|
|
RESET SLAVE;
|
|
connection master;
|
|
set global disconnect_on_expired_password=OFF;
|
|
connection slave;
|
|
START SLAVE;
|
|
include/wait_for_slave_io_error.inc [errno=1820]
|
|
connection master;
|
|
DROP USER 'repl_user';
|
|
set global disconnect_on_expired_password=default;
|
|
connection slave;
|
|
include/stop_slave_sql.inc
|
|
CHANGE MASTER TO MASTER_USER='root';
|
|
RESET SLAVE;
|
|
include/rpl_end.inc
|