Change MySQL root Password using Command Line in WAMP Server

You can change root password using command line in wampserver or wampmanager, just follow the steps to change the root password.

• click on wampmanager, go to MySQL and Open the MySQL Console.
• By default the password in null (means no password). Just hit Enter
• Run the following sql command.

SQL Query to Change root Password in WAMP

mysql> update mysql.user SET password=password("new_password") where user="root"; hit enter

Your password updated and you will get Query OK message. Then click on the wampserver (bottom right) which is running in task bar and select Restart All Services.