How to modify the root password of MySQL
How to modify the root password of MySQL
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-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: www.bitsCN.com
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;
BitsCN.com