WAMP Mysqli: Your password has expired
When you try to login your phpmydmin service, or try to use sql connection from one of your LAMP providers, you might experience a warning message like this:
Warning: mysqli::mysqli(): (HY000/1862): Your password has expired. To log in you must change it using a client that supports expired passwords.
This means that there is an expiration timeout set for your account.
To solve this problem (assuming that you are running WAMP or XAMP installations):
1. find the mysql installation folder
2. login to your mysql account
mysql -u root -p
3. reset your password and make sure it will never expires again
mysql> ALTER USER `root`@`localhost` IDENTIFIED BY 'NEW_PASSWORD', `root`@`localhost` PASSWORD EXPIRE NEVER;
Now, you can go and login your phpmyadmin service and login through php pages.