Reset MySQL password | INFO-TECH

Reset MySQL password

Some days back i just forget this password for Mysql and there is very easy way to reset this password, simply follow below steps : (Windows XP)

Go to control panel > administrative tasks > services
Select mysql service from right pane
right click on it and 'STOP' the service
There is a way to start the server with special init file which you can create as follows :

UPDATE mysql.user SET Password=PASSWORD('girish') WHERE User='root';

FLUSH PRIVILEGES;

Copy above 2 lines and paste it in notepad and save this file as : mysqlpwdreset.txt
Now fire up : C:\mysql\bin\mysqld-nt --init-file=C:\\mysqlpwdreset.txt

For More Information Click here

Thats it! Now Fire up your mysql and enter this new password !

Thank You,

0 comments:

Post a Comment