diff options
Diffstat (limited to 'mysql-test/main/password_expiration.result')
-rw-r--r-- | mysql-test/main/password_expiration.result | 38 |
1 files changed, 19 insertions, 19 deletions
diff --git a/mysql-test/main/password_expiration.result b/mysql-test/main/password_expiration.result index 73c436aecd2..bb39d8788dc 100644 --- a/mysql-test/main/password_expiration.result +++ b/mysql-test/main/password_expiration.result @@ -103,32 +103,32 @@ drop user user1@localhost; create user user1@localhost; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' +CREATE USER `user1`@`localhost` alter user user1@localhost password expire; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE +CREATE USER `user1`@`localhost` PASSWORD EXPIRE set password for user1@localhost= password(''); alter user user1@localhost password expire default; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' +CREATE USER `user1`@`localhost` alter user user1@localhost password expire never; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE NEVER +CREATE USER `user1`@`localhost` PASSWORD EXPIRE NEVER alter user user1@localhost password expire interval 123 day; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE INTERVAL 123 DAY +CREATE USER `user1`@`localhost` PASSWORD EXPIRE INTERVAL 123 DAY alter user user1@localhost password expire; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE +CREATE USER `user1`@`localhost` PASSWORD EXPIRE set password for user1@localhost= password(''); show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE INTERVAL 123 DAY +CREATE USER `user1`@`localhost` PASSWORD EXPIRE INTERVAL 123 DAY drop user user1@localhost; # # Incorrect INTERVAL values should be rejected @@ -141,52 +141,52 @@ ERROR HY000: Incorrect DAY value: '0' create user user1@localhost; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' +CREATE USER `user1`@`localhost` flush privileges; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE NEVER +CREATE USER `user1`@`localhost` PASSWORD EXPIRE NEVER alter user user1@localhost password expire; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE +CREATE USER `user1`@`localhost` PASSWORD EXPIRE flush privileges; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE +CREATE USER `user1`@`localhost` PASSWORD EXPIRE set password for user1@localhost= password(''); alter user user1@localhost password expire default; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' +CREATE USER `user1`@`localhost` flush privileges; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE NEVER +CREATE USER `user1`@`localhost` PASSWORD EXPIRE NEVER alter user user1@localhost password expire never; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE NEVER +CREATE USER `user1`@`localhost` PASSWORD EXPIRE NEVER flush privileges; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE NEVER +CREATE USER `user1`@`localhost` PASSWORD EXPIRE NEVER alter user user1@localhost password expire interval 123 day; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE INTERVAL 123 DAY +CREATE USER `user1`@`localhost` PASSWORD EXPIRE INTERVAL 123 DAY flush privileges; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE NEVER +CREATE USER `user1`@`localhost` PASSWORD EXPIRE NEVER alter user user1@localhost password expire; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE +CREATE USER `user1`@`localhost` PASSWORD EXPIRE flush privileges; show create user user1@localhost; CREATE USER for user1@localhost -CREATE USER 'user1'@'localhost' PASSWORD EXPIRE +CREATE USER `user1`@`localhost` PASSWORD EXPIRE set global disconnect_on_expired_password=ON; connect(localhost,user1,,test,MYSQL_PORT,MYSQL_SOCK); connect con1,localhost,user1; |