To recover the MySQL root password if forgotten.

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

  --skip-grant-tables

  option.

• Start the mysql client with the

      -u root

  option.

• 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