WAMP Mysqli: Your password has expired

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.


added 7 years ago

- What is x-ray?
- The Wink home automation
- Skype works, shows I have internet, but browser wont go online
- If LED lights are so efficient then why do they get almost as hot as incandescents?
- How to correctly optimize your SSD for windows 10
- WAMP Mysqli: Your password has expired
- MySQL Dump/Restore, Dumping MySQL Database and Tables using MysqlDump command
- Source Code of Matrix Multiplication
- How to create your own PHP caching system? A simple example
- Domain Life Cycle
- Comparison of Random Functions According to their Exploration Performance (STL, .NET, Java)
- How to draw double buffered in C# or Java using GDI+
- How to recover Ubuntu after installing Windows using Ubuntu live cd
2
1