Reset MySQL 5.1 Root password

Sometimes you might want to reset your used password since it is used for long time.

To reset MySQL database password, you may need to consider different Operating System and it’s version will have minor differences during the root password reset.

Today, Mick Genie will guide you how to reset MySQL database v5.1  through Windows Operating System and Linux Operating System.

For Windows Operating System,
1. Firstly, create a text file and name it as resetpassword.txt and you may save it to C drive.
2. Enter the following word to your text file.

UPDATE mysql.user SET Password=PASSWORD('[email protected]') WHERE User='root';

Continue reading Reset MySQL 5.1 Root password