Modify the root password of MySQL (Linux environment) _ MySQL

The first method to change the root password of MySQL (Linux) is as follows:
Root User login system

/Usr/local/mysql/bin/mysqladmin-u root-p password new password

Enter password old password

Method 2:

Log on to the mysql database as a root user.

Mysql> update mysql. user set password = password ("new password") where User = "root ";

Mysql> flush privileges;

Mysql> quit;

What should I do if I forget the root password of mysql?

If MySQL is running, first stop the mysql process: killall mysqld

Start MySQL (abnormal startup):/usr/local/mysql/bin/mysqld_safe