Resetting MySQL Root Password

Resetting the root password for MySQL can be done by using the following commands:


1: use mysql;
2: UPDATE user SET Password = PASSWORD("newpassword") WHERE user = 'root';
3: flush privileges;


(Tested on MySQL 5.1.11)