MySQL - Reset root password

To recover the MySQL root password if forgotten.

• Stop the mysqld daemon process.
• Start the mysqld daemon process:

  --skip-grant-tables

• Start the mysql client

  -u root

• Execute the command

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

• Execute the command

  FLUSH PRIVILEGES;

• Use mysqladmin to shut down the MySQL daemon:

  mysqladmin shutdown

• Start MySQL server as per normal.