After you forget the Mysql password

I recently forgot my mysql password. I learned four solutions online and recorded them.

Method 1: use the set password command
Mysql-u root
Mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass ');
Method 2: Use mysqladmin
Mysqladmin-u root password "newpass"
If the root user has set a password, use the following method:
Mysqladmin-u root password oldpass "newpass"
Method 3: Use UPDATE to directly edit the user table
Mysql-u root
Mysql> use mysql;
Mysql> UPDATE user SET Password = PASSWORD ('newpass') WHERE user = 'root ';
Mysql> flush privileges;
When the root password is lost
Mysqld_safe -- skip-grant-tables &
Mysql-u root mysql
Mysql> UPDATE user SET password = PASSWORD ("new password") WHERE user = 'root ';
Mysql> flush privileges;

Hope to help you.