忘记root password

Alternatively, on any platform, you can set the new password using the mysql client(but this approach is less secure):

1. Stop mysqld and restart it with the --skip-grant-tables --user=root options (Windows users omit the --user=root portion).

2. Connect to the mysqld server with this command:

   shell> mysql -u root
   

3. Issue the following statements in the mysql client:

   mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')
       ->                   WHERE User='root';
   mysql> FLUSH PRIVILEGES;
   

   Replace “newpwd” with the actual root password that you want to use.

4. You should be able to connect using the new password.