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

mysql>quit ENTER

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))

This entry was posted in wamp server, Website Hosting and tagged , . Bookmark the permalink.

One Response to WAMP Server – MySQL – Resetting the Root Password (Windows)

  1. DL says:

    Thanks! You’re the FIRST and ONLY person who actually provided legit instructions on how to set the root password.

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Spam protection by WP Captcha-Free