Reset Mysql Password in Linux

1. Stop mysqld and restart it with the --skip-grant-tables --user=root options (Windows users omit the --user=root portion).


2. Connect to the mysqld server with this command:
   shell> mysql -u root


3. Issue the following statements in the mysql client:
   mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
   mysql> FLUSH PRIVILEGES;
   Replace “newpwd” with the actual root password that you want to use.
   
   


4. You should be able to connect using the new password.