All I need is a rhythm divine
Lost in the music, your heart will be mine
All I need is to look in your eyes
Viva la musica, say you'll be mine

How to Reset a MySQL Password in 5 Easy Steps

  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 UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’;
  5. Execute the FLUSH PRIVILEGES; command.

These steps reset the password for the “root” account to “password”. To change the password for a different account, or to set a different password, just edit…