mirror of
https://github.com/MariaDB/server.git
synced 2025-10-30 18:36:12 +01:00
41 lines
1.7 KiB
Text
41 lines
1.7 KiB
Text
** Setup **
|
|
|
|
SET @old_secure_auth = @@GLOBAL.secure_auth;
|
|
'#--------------------FN_DYNVARS_144_01-------------------------#'
|
|
SELECT @@GLOBAL.secure_auth;
|
|
@@GLOBAL.secure_auth
|
|
1
|
|
1 / ON Expected
|
|
'#--------------------FN_DYNVARS_144_02-------------------------#'
|
|
SET GLOBAL secure_auth = OFF;
|
|
Warnings:
|
|
Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
|
|
CREATE USER 'testUser'@'localhost' IDENTIFIED BY 'newpass';
|
|
connect con_user1,localhost,testUser,newpass,;
|
|
connection default;
|
|
SET PASSWORD FOR 'testUser'@'localhost' = OLD_PASSWORD('newpass');
|
|
connect con_user2,localhost,testUser,newpass,;
|
|
connection default;
|
|
'#--------------------FN_DYNVARS_144_03-------------------------#'
|
|
SET GLOBAL secure_auth = ON;
|
|
Warnings:
|
|
Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
|
|
SET PASSWORD FOR 'testUser'@'localhost' = PASSWORD('newpass');
|
|
connect con_user3,localhost,testUser,newpass,;
|
|
connection default;
|
|
SET PASSWORD FOR 'testUser'@'localhost' = OLD_PASSWORD('newpass');
|
|
ERROR HY000: Server is running in --secure-auth mode, but 'testUser'@'localhost' has a password in the old format; please change the password to the new format
|
|
Expected error "Server is in secure auth mode"
|
|
connection default;
|
|
SET PASSWORD FOR 'testUser'@'localhost' = PASSWORD('newpass');
|
|
connect con_user4,localhost,testUser,newpass,;
|
|
connection default;
|
|
SET GLOBAL secure_auth = @old_secure_auth;
|
|
Warnings:
|
|
Warning 1287 '@@secure_auth' is deprecated and will be removed in a future release
|
|
disconnect con_user1;
|
|
disconnect con_user2;
|
|
disconnect con_user3;
|
|
disconnect con_user4;
|
|
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'testUser'@'localhost';
|
|
DROP USER 'testUser'@'localhost';
|