Method 1: Use the SETPASSWORD command mysql-urootmysqlSETPASSWORDFORroot @ localhostPASSWORD (newpass); Method 2: Use mysqladminmysqladmin-urootpasswordnewpass. If the root has already set a password, use the following method:
Method 1: use the set password command mysql-u root mysql set password for 'root' @ 'localhost' = PASSWORD ('newpass'); Method 2: use mysqladmin-u root password newpass if the root user has set a password, use the following method: mysqladmin-u root password oldpass newp
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;