Reset MYSQL root password

Simple steps to reset the mysql root password if you have forgotten it.

1. Stop the mysqld daemon process.

2. Start the mysqld daemon process with the '–skip-grant-tables' option.

3. Start the mysql client with the -u root option.

4. Execute the following:

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

5. Execute the following:

FLUSH PRIVILEGES;