I have lost my MySQL root password, how can I get in?
Stop the mysqld daemon process.
Start the mysqld daemon process with the —skip-grant-tables option.
Start the mysql client with the -u root option.
Execute the UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’;
Execute the FLUSH PRIVILEGES; command
