Modify the password of the MySQL root user

1. Cat/root/.mysql_secret------------get random passwords generated when MySQL is installed
Service MySQL start--------------start MySQL Services
Mysql-uroot-p----------------into MySQL, using the random password obtained before
SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' PASSWORD '); ------------------set the root account password to password on the MySQL command line
Quit-------------quit MySQL command line
Service MySQL Restart-----------restart MySQL Services

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"

3. Edit the user table directly using update

Mysql-u Root

mysql> use MySQL;

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

mysql> FLUSH privileges;

4, in the loss of root password, you can do this:

Mysqld_safe--skip-grant-tables&

Mysql-u Root MySQL

mysql> UPDATE user SET Password=password ("New password") WHERE user= ' root ';

mysql> FLUSH privileges;

Modify the password of the MySQL root user