Search code examples
wampserver

how to reset wamp server password


I've put the password in the main phpmyadmin and not one of the databases. How can I even access it if can't even have the chance to input the password.


Solution

  • Take a look at reseting the MySQL root password here.

    UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
    FLUSH PRIVILEGES;