Several methods of MySQL change password on Linux and how to modify MySQL forgot password

Method 1: Use the Set password command

Mysql-u Root

mysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');

Method 2: Use Mysqladmin (this is the Linu command line interface)

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

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

In/etc/my.conf, add a sentence in the [MySQL] section:

Skip-grant-tables

Save exit, restart MySQL

/etc/init.d/mysqld restart

Use the command to enter MySQL:

Mysql-u root-p
Press ENTER twice to enter MySQL
Mysql> Usemysql;
Mysql>update user Set Password = password (' 123456 ') where user = ' root ';
Re-edit/ETC/MY.CNF
Delete or comment out Skip-grant-tables
Restart Service OK

This article is from the "Wang Liming" blog, make sure to keep this source http://afterdawn.blog.51cto.com/7503144/1834707

Several methods of MySQL change password on Linux and how to modify MySQL forgot password