WAMP Server – MySQL – Resetting the Root Password (Windows)

1. Log on to your system as Administrator.

2. Click on the Wamp server icon > MySQL > MySQL Console

3. Enter password: LEAVE BLANK AND HIT ENTER

4. mysql> UPDATE mysql.user SET Password=PASSWORD(‘MyNewPass’) WHERE User=’root’; ENTER
Query OK

5. mysql>FLUSH PRIVILEGES; ENTER
mysql>quit ENTER
mysql>bye

6. Edit phpmyadmin file called “config.inc.php” enter ‘MyNewPass’ ($cfg['Servers'][$i]['password'] = ‘MyNewPass‘;)

7. Restart all services

8. Clear all cookies – I got the No password error and it was because of the cookies. (ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: NO))