How do I change my root password in windows?

Asked

Viewed 25 times

0

i lost the root password I put in when I installed Mysql, but I don’t know how to reset/change without knowing the password

mysql

1 answer

1


  • Stop the Mysql completely. This can be done by accessing the Services window Windows XP, Windows Server 2003 and the like, where you can stop the service Mysql.
  • Open the command prompt by typing cmd inside the window of execute. Inside it navigate to the folder bin of Mysql. Ex: C:\mysql\bin using the command cd.
  • Run the following command at the command prompt: mysqld.exe-u root - skip-grant-tables
  • Leave the current command prompt as is, and open a new command prompt.
  • Go to the folder bin of MysqL, Ex: C: mysql bin using command cd. Typo mysql and press Enter.
  • Now you must have the command prompt of Mysql working. Type use mysql; to select the database mysql.
  • Run the following command to update the password: UPDATE user SET Password = PASSWORD ( 'NOVA_SENHA') WHERE User = 'root';

Source: Resetting MYSQL root password in WINDOWS XP/server 2003

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.