MySQL Change Password Change MySQL root password in Windows
Example
When we want to change root password in windows, We need to follow following steps :
Step 1 : Start your Command Prompt by using any of below method :
Perss Crtl+R or Goto Start Menu > Run and then type cmd and hit enter
Step 2 :
Change your directory to where MYSQL is installed, In my case it's
C:\> cd C:\mysql\bin
Step 3 : Now we need to start mysql command prompt
C:\mysql\bin> mysql -u root mysql
Step 4 : Fire query to change root password
mysql> SET PASSWORD FOR root@localhost=PASSWORD('my_new_password');
