How to change the password of mysql and how to forget the root password

Method 1: use the set password command
Copy codeThe Code is as follows:
Mysql-u root
Mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass ');

Method 2: Use mysqladmin
Copy codeThe Code is as follows:
Mysqladmin-u root password "newpass"

If the root user has set a password, use the following method:
Copy codeThe Code is as follows:
Mysqladmin-u root password oldpass "newpass"

Method 3: Use UPDATE to directly edit the user table
Copy codeThe Code is as follows:
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
Copy codeThe Code is as follows:
Mysqld_safe -- skip-grant-tables &
Mysql-u root mysql
Mysql> UPDATE user SET password = PASSWORD ("new password") WHERE user = 'root ';
Mysql> flush privileges;