Multiple methods for changing the root password of MySQL

Multiple methods for changing the root password of MySQL

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;