MySQL password expire setting for users and global
At script level you will get this message. Your PhpMyAdmin will also give you error message.
Error: Unable to connect to MySQL.
Debugging errno: 1862
Debugging error: Your password has expired. To log in you must change it using a client that supports expired passwords.
Open your MySQL Command Line Control
Enter your password ( it will accept ) and then enter this
SET GLOBAL default_password_lifetime = 0;
The password will never expire now.
To update password
ALTER USER 'usrname'@'localhost' IDENTIFIED BY 'new-password';
To expire any user account
ALTER USER 'user_id'@'localhost' PASSWORD EXPIRE;
Not to expire any user password
ALTER USER 'my_userid'@'localhost' PASSWORD EXPIRE NEVER
To set the password duration for all the users ( global ) , 60 days
SET GLOBAL default_password_lifetime = 60;
For a user to set a different days than the global set value
ALTER USER 'userid'@'localhost' PASSWORD EXPIRE INTERVAL 30 DAY;