Simple Method to Regain MySQL 'root' Password on WAMP
Having accidentally locked yourself out of PHPMyAdmin by forgetting your 'root'@'localhost' password on WAMP 2.5, it's understandable to feel frustrated.
Resetting the Password
- Stop the MySQL Service: Navigate to WAMPManager > MySQL > Service > Stop Service.
- Edit the my.ini File: In WAMPManager, select MySQL > my.ini and add "skip-grant-tables" under the [wampmysqld](32bit) or [wampmysqld64](64bit) section.
- Restart MySQL: Return to WAMPManager > MySQL > Service > Start/Resume Service.
- Open MySQL Console: Access MySQL Console via WAMPManager > MySQL > MySQL Console.
- Reset Password: Depending on the MySQL version, execute the following commands (with semicolons at the end of each line):
- Pre-MySQL 5.7: UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
- Post-MySQL 5.7: UPDATE mysql.user SET authentication_string=PASSWORD('MyNewPass') WHERE User='root';
- Flush Privileges: Execute FLUSH PRIVILEGES;
- Exit MySQL Console: Type 'quit' at the mysql command prompt.
- Stop MySQL Service: Repeat step 1.
- Remove "skip-grant-tables": Open my.ini and remove the skip-grant-tables entry (it poses a security risk if left unchanged).
- Restart MySQL: Implement step 3.
- Disable Password Expiration (Optional): Connect to MySQL Console, run the query ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;.
By completing these steps, you should successfully regain access to PHPMyAdmin as the 'root' user with your newly set password.
The above is the detailed content of How to Reset Your MySQL 'root' Password on WAMP?. For more information, please follow other related articles on the PHP Chinese website!