Edit File: password_expired.result
======================================================================================= Checking the password expiry with the users created with all 3 plugable authentication ======================================================================================= set @@global.secure_auth=0; Creating a user with respect to all the 3 password authentication plugin **** Creating user with mysql_native_password plugin select @@session.old_passwords; @@session.old_passwords 0 0 Expected CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED BY 'abc'; **** Creating user with mysql_old_password plugin set @@session.old_passwords=1; CREATE USER 'Tanjotuser2'@'localhost' IDENTIFIED WITH 'mysql_old_password'; SET PASSWORD for 'Tanjotuser2'@'localhost' = password('abc'); Warnings: Warning 1287 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead **** Creating user with sha256_password plugin set @@session.old_passwords=2; CREATE USER 'Tanjotuser3'@'localhost' IDENTIFIED WITH 'sha256_password'; SET PASSWORD for 'Tanjotuser3'@'localhost' = password('abc'); **** Validating the plugin names select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password'; (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password' 1 1 Expected select (select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_old_password'; (select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_old_password' 1 1 Expected select (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password'; (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password' 1 1 Expected **** Validating the password expiry flag in the mysql.user table select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N' 1 1 Expected **** Expirying password from root login for the 3 created users Alter user 'Tanjotuser1'@'localhost' password expire; ERROR 42000: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation select 1; 1 1 1 Expected Alter user 'Tanjotuser2'@'localhost' password expire; ERROR 42000: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation select 1; 1 1 1 Expected Alter user 'Tanjotuser3'@'localhost' password expire; ERROR 42000: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation select 1; 1 1 1 Expected **** Validating the password expiry flag in the mysql.user table should not be altered select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N' 1 1 Expected **** These 3 users still should be able to login and work properly select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected **** Expirying password from root login for the 3 created users using Alter user Alter user 'Tanjotuser1'@'localhost' password expire; Alter user 'Tanjotuser2'@'localhost' password expire; Alter user 'Tanjotuser3'@'localhost' password expire; **** Validating the password expiry flag in the mysql.user table select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='Y'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='Y' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='Y'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='Y' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='Y'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='Y' 1 1 Expected **** checking user access after password expiry select 1; ERROR HY000: You must SET PASSWORD before executing this statement select 1; ERROR HY000: You must SET PASSWORD before executing this statement select 1; ERROR HY000: You must SET PASSWORD before executing this statement At the same time the open sessions for these users should able to work properly. select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected setting passwords from the new connections. set @@session.old_passwords=1; set password=password('abcd'); ERROR HY000: Password hash should be a 41-digit hexadecimal number select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=2; set password=password('abcd'); ERROR HY000: Password hash should be a 41-digit hexadecimal number select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=0; set password=password('abcd'); select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N' 1 1 Expected set @@session.old_passwords=0; set password=password('abcd'); ERROR HY000: Password hash should be a 16-digit hexadecimal number select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=2; set password=password('abcd'); ERROR HY000: Password hash should be a 16-digit hexadecimal number select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=1; set password=password('abcd'); Warnings: Warning 1287 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N' 1 1 Expected set @@session.old_passwords=0; set password=password('abcd'); ERROR HY000: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=1; set password=password('abcd'); ERROR HY000: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=2; set password=password('abcd'); select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N' 1 1 Expected **** logging the 3 users with the new passwords select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected Disconnecting the open sessions and dropping the created users drop user 'Tanjotuser1'@'localhost'; drop user 'Tanjotuser2'@'localhost'; drop user 'Tanjotuser3'@'localhost'; ======================================================================================= Checking the password expiry using the update command on mysql.user table ======================================================================================= Creating a user with respect to all the 3 password authentication plugin **** Creating user with mysql_native_password plugin set @@session.old_passwords=0; CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED BY 'abc'; **** Creating user with mysql_old_password plugin set @@session.old_passwords=1; CREATE USER 'Tanjotuser2'@'localhost' IDENTIFIED WITH 'mysql_old_password'; SET PASSWORD for 'Tanjotuser2'@'localhost' = password('abc'); Warnings: Warning 1287 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead **** Creating user with sha256_password plugin set @@session.old_passwords=2; CREATE USER 'Tanjotuser3'@'localhost' IDENTIFIED WITH 'sha256_password'; SET PASSWORD for 'Tanjotuser3'@'localhost' = password('abc'); **** Validating the plugin names select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password'; (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password' 1 1 Expected select (select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_old_password'; (select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_old_password' 1 1 Expected select (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password'; (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password' 1 1 Expected **** Validating the password expiry flag in the mysql.user table select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N' 1 1 Expected **** Making connections from each of these created users select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected **** Expirying password from root login for the 3 created users using update command update mysql.user set password_expired='Y' where User='Tanjotuser1' and Host='localhost'; update mysql.user set password_expired='Y' where User='Tanjotuser2' and Host='localhost'; update mysql.user set password_expired='Y' where User='Tanjotuser3' and Host='localhost'; **** connecting client before flush privileges select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected **** flush privileges flush privileges; **** connecting client after flush privileges select 1; ERROR HY000: You must SET PASSWORD before executing this statement select 1; ERROR HY000: You must SET PASSWORD before executing this statement select 1; ERROR HY000: You must SET PASSWORD before executing this statement **** checking the previous open connections select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected **** Resetting the password set @@session.old_passwords=1; set password=password('abcd'); ERROR HY000: Password hash should be a 41-digit hexadecimal number select 1; 1 1 1 Expected set @@session.old_passwords=2; set password=password('abcd'); ERROR HY000: Password hash should be a 41-digit hexadecimal number select 1; 1 1 1 Expected set @@session.old_passwords=0; set password=password('abcd'); select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N' 1 1 Expected set @@session.old_passwords=0; set password=password('abcd'); ERROR HY000: Password hash should be a 16-digit hexadecimal number select 1; 1 1 1 Expected set @@session.old_passwords=2; set password=password('abcd'); ERROR HY000: Password hash should be a 16-digit hexadecimal number select 1; 1 1 1 Expected set @@session.old_passwords=1; set password=password('abcd'); Warnings: Warning 1287 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N' 1 1 Expected set @@session.old_passwords=0; set password=password('abcd'); ERROR HY000: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. select 1; 1 1 1 Expected set @@session.old_passwords=1; set password=password('abcd'); ERROR HY000: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. select 1; 1 1 1 Expected set @@session.old_passwords=2; set password=password('abcd'); select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N' 1 1 Expected **** Logging with the new password select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected **** connecting client after resetting the password Disconnecting the open sessions and dropping the created users drop user 'Tanjotuser1'@'localhost'; drop user 'Tanjotuser2'@'localhost'; drop user 'Tanjotuser3'@'localhost'; ================================================================================================= Starting the server with the default authentication sha256_password ================================================================================================= # Restart server with default-authentication-plugin=sha256_password; ======================================================================================= Checking the password expiry with the users created with all 3 plugable authentication ======================================================================================= set @@global.secure_auth=0; Creating a user with respect to all the 3 password authentication plugin **** Creating user with mysql_native_password plugin set @@session.old_passwords=0; CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password'; SET PASSWORD for 'Tanjotuser1'@'localhost' = password('abc'); **** Creating user with mysql_old_password plugin set @@session.old_passwords=1; CREATE USER 'Tanjotuser2'@'localhost' IDENTIFIED WITH 'mysql_old_password'; SET PASSWORD for 'Tanjotuser2'@'localhost' = password('abc'); Warnings: Warning 1287 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead **** Creating user with sha256_password plugin set @@session.old_passwords=2; CREATE USER 'Tanjotuser3'@'localhost' IDENTIFIED WITH 'sha256_password'; SET PASSWORD for 'Tanjotuser3'@'localhost' = password('abc'); **** Validating the plugin names select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password'; (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password' 1 1 Expected select (select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_old_password'; (select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_old_password' 1 1 Expected select (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password'; (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password' 1 1 Expected **** Validating the password expiry flag in the mysql.user table select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N' 1 1 Expected **** Expirying password from root login for the 3 created users Alter user 'Tanjotuser1'@'localhost' password expire; ERROR 42000: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation select 1; 1 1 1 Expected Alter user 'Tanjotuser2'@'localhost' password expire; ERROR 42000: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation select 1; 1 1 1 Expected Alter user 'Tanjotuser3'@'localhost' password expire; ERROR 42000: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation select 1; 1 1 1 Expected **** Validating the password expiry flag in the mysql.user table should not be altered select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N' 1 1 Expected **** These 3 users still should be able to login and work properly select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected **** Expirying password from root login for the 3 created users using Alter user Alter user 'Tanjotuser1'@'localhost' password expire; Alter user 'Tanjotuser2'@'localhost' password expire; Alter user 'Tanjotuser3'@'localhost' password expire; **** Validating the password expiry flag in the mysql.user table select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='Y'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='Y' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='Y'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='Y' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='Y'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='Y' 1 1 Expected **** checking user access after password expiry select 1; ERROR HY000: You must SET PASSWORD before executing this statement select 1; ERROR HY000: You must SET PASSWORD before executing this statement select 1; ERROR HY000: You must SET PASSWORD before executing this statement At the same time the open sessions for these users should able to work properly. select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected setting passwords from the new connections. set @@session.old_passwords=1; set password=password('abcd'); ERROR HY000: Password hash should be a 41-digit hexadecimal number select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=2; set password=password('abcd'); ERROR HY000: Password hash should be a 41-digit hexadecimal number select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=0; set password=password('abcd'); select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N' 1 1 Expected set @@session.old_passwords=0; set password=password('abcd'); ERROR HY000: Password hash should be a 16-digit hexadecimal number select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=2; set password=password('abcd'); ERROR HY000: Password hash should be a 16-digit hexadecimal number select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=1; set password=password('abcd'); Warnings: Warning 1287 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N' 1 1 Expected set @@session.old_passwords=0; set password=password('abcd'); ERROR HY000: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=1; set password=password('abcd'); ERROR HY000: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. select 1; ERROR HY000: You must SET PASSWORD before executing this statement set @@session.old_passwords=2; set password=password('abcd'); select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N' 1 1 Expected **** logging the 3 users with the new passwords select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected Disconnecting the open sessions and dropping the created users drop user 'Tanjotuser1'@'localhost'; drop user 'Tanjotuser2'@'localhost'; drop user 'Tanjotuser3'@'localhost'; ======================================================================================= Checking the password expiry using the update command on mysql.user table ======================================================================================= Creating a user with respect to all the 3 password authentication plugin **** Creating user with mysql_native_password plugin set @@session.old_passwords=0; CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password'; SET PASSWORD for 'Tanjotuser1'@'localhost' = password('abc'); **** Creating user with mysql_old_password plugin set @@session.old_passwords=1; CREATE USER 'Tanjotuser2'@'localhost' IDENTIFIED WITH 'mysql_old_password'; SET PASSWORD for 'Tanjotuser2'@'localhost' = password('abc'); Warnings: Warning 1287 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead **** Creating user with sha256_password plugin set @@session.old_passwords=2; CREATE USER 'Tanjotuser3'@'localhost' IDENTIFIED WITH 'sha256_password'; SET PASSWORD for 'Tanjotuser3'@'localhost' = password('abc'); **** Validating the plugin names select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password'; (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password' 1 1 Expected select (select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_old_password'; (select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_old_password' 1 1 Expected select (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password'; (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password' 1 1 Expected **** Validating the password expiry flag in the mysql.user table select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N' 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N' 1 1 Expected **** Making connections from each of these created users select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected **** Expirying password from root login for the 3 created users using update command update mysql.user set password_expired='Y' where User='Tanjotuser1' and Host='localhost'; update mysql.user set password_expired='Y' where User='Tanjotuser2' and Host='localhost'; update mysql.user set password_expired='Y' where User='Tanjotuser3' and Host='localhost'; **** connecting client before flush privileges select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected **** flush privileges flush privileges; **** connecting client after flush privileges select 1; ERROR HY000: You must SET PASSWORD before executing this statement select 1; ERROR HY000: You must SET PASSWORD before executing this statement select 1; ERROR HY000: You must SET PASSWORD before executing this statement **** checking the previous open connections select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected **** Resetting the password set @@session.old_passwords=1; set password=password('abcd'); ERROR HY000: Password hash should be a 41-digit hexadecimal number select 1; 1 1 1 Expected set @@session.old_passwords=2; set password=password('abcd'); ERROR HY000: Password hash should be a 41-digit hexadecimal number select 1; 1 1 1 Expected set @@session.old_passwords=0; set password=password('abcd'); select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser1' and Host='localhost')='N' 1 1 Expected set @@session.old_passwords=0; set password=password('abcd'); ERROR HY000: Password hash should be a 16-digit hexadecimal number select 1; 1 1 1 Expected set @@session.old_passwords=2; set password=password('abcd'); ERROR HY000: Password hash should be a 16-digit hexadecimal number select 1; 1 1 1 Expected set @@session.old_passwords=1; set password=password('abcd'); Warnings: Warning 1287 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser2' and Host='localhost')='N' 1 1 Expected set @@session.old_passwords=0; set password=password('abcd'); ERROR HY000: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. select 1; 1 1 1 Expected set @@session.old_passwords=1; set password=password('abcd'); ERROR HY000: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. select 1; 1 1 1 Expected set @@session.old_passwords=2; set password=password('abcd'); select 1; 1 1 1 Expected select (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N'; (select password_expired from mysql.user where User='Tanjotuser3' and Host='localhost')='N' 1 1 Expected **** Logging with the new password select 1; 1 1 1 Expected select 1; 1 1 1 Expected select 1; 1 1 1 Expected **** connecting client after resetting the password Disconnecting the open sessions and dropping the created users drop user 'Tanjotuser1'@'localhost'; drop user 'Tanjotuser2'@'localhost'; drop user 'Tanjotuser3'@'localhost'; set @@session.old_passwords=default;