MySQL multiple ways to change the root password (including missing passwords)

It is hereby stated that the specific source of the study in the network above is not clear. If there is infringement please inform the author to revoke, thank you!

MySQL multiple ways to change the root password (including missing passwords)

Note: MySQL5.7 and later versions may change somewhat

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 Root has already set a password, use the following method

mysqladmin-u root password Oldpass "Newpass"

Method 3: Edit the user table directly with update (recommended)

Mysql-u root-p

mysql> use MySQL;

mysql> UPDATE user SET Password = Password (' newpass ') WHERE user = ' root ';

mysql> FLUSH privileges;

This can be done 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;

MySQL multiple ways to change the root password (including missing passwords)