MySQL several ways to change the root account password

To modify the root account password in MySQL, the following four methods have been tested .

Method 1: Use the Set password command

First log in to MySQL.
Format:mysql> set password for user name @localhost = password (' new password ');
Example:mysql> set password for [email protected] = password (' admin ');
The above example changes the user root password to admin

Method 2: Use Mysqladmin

　Format: Mysqladmin-u username-P Old password password new password
Example: mysqladmin-uroot-p123456 password admin
The above example changes the user root original password 123456 to the new password admin

Method 3: Edit the user table directly with update

　First log in to MySQL.
mysql> use MySQL;
mysql> Update user Set Password=password (' admin ') where user= ' root ' and host= ' localhost ';
mysql> flush Privileges;

Method 4: When you forget the root password, you can do so.

Take windows as an example:
1. Close the running MySQL service.
2. Open the DOS window and go to the Mysql\bin directory.
3. Enter Mysqld--skip-grant-tables carriage return. --skip-grant-tables means skipping permission table authentication when starting the MySQL service.
4. Open a DOS window again (because the DOS window is no longer moving), go to the Mysql\bin directory.
5. Enter MySQL return and, if successful, the MySQL prompt > will appear.
6. Connection rights database: use MySQL;.
6. Change Password: Update user set Password=password ("admin") where user= "root"; (don't forget the last semicolon).
7. Refresh permissions (required steps): flush privileges;.
8. Quit quit.
9. Log off the system, and then enter, using the username root and the new password just set to admin login.

MySQL several ways to change the root account password