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

C:\wamp64\bin\mysql\mysql5.7.9\bin

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.