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;
changing default password life time
The password will never expire now.

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;
In all these cases Mysql keeps the user in Sandbox Mode , that is the user is allowed for changing the password onlyl.

PHP MYSQLI connection string



plus2net.com



Post your comments , suggestion , error , requirements etc here .
















We use cookies to improve your browsing experience. . Learn more
HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2020 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer