Change directory to where you installed mysql to: C: \ cd C: mysqlbin. Switch to mysql command line: C: \mysqlbin mysql u root p. Then set a default password: mysql SET PASSWORD FOR where newpass is the password you want to use. mysql windows command line change root password Reset Forgotten MySql root Password Under Windows. 1. Stop your MySQL server completely. This can be done from Wamp (if you use it), or start services. msc using Run window, and stop the service there. 2. Open your MSDOS command prompt using cmd inside the Run window. Then go to your MySQL bin folder, such as C: \MySQL\bin.
mysql update user set where User'root In the above query, the newpassword represents your new password. Replace it with whatever your choice but make sure to use high strength password. Finally, reload the privileges of MySQL server using below command. mysql windows command line change root password
In case if you have Xampp installed. Now, reset the root password with the MySQL query update mysql. user set where user'root Exit the command prompt. Restart the mysql windows service that was turned off in step 4. Now you will be able to login to mysql using password as root. Oct 17, 2017 Where NEWPASSWORD is the password to be used. Now, when you log into MySQL, with the command mysql u root p, you will be prompted to enter the newly configured password. An alternative method for setting the root password for the first time, one that also adds a bit of security to your MySQL database, is to use the command. mysql windows command line change root password