MySQL password change methods, yc sorting

MySQL password change methods, yc sorting

Reprinted please indicate the source http://blog.csdn.net/yc7369

MySQL password change methods

I have sorted out the following four methods to change the root password in MySQL, which may be helpful to you!

Method 1: use the set password command

Mysql-uroot

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-uroot

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-uroot mysql

Mysql> UPDATE user SET password = PASSWORD ("new password") WHERE user = 'root ';

Mysql> flush privileges;

The following statement is available in mysql 5.6. It should be similar in other versions.

Reprinted please indicate the source http://blog.csdn.net/yc7369