Several ways MySQL modifies the root password

This article has compiled four ways to change the root password in MySQL, and we hope to help you. All methods have been tested and passed.

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 root@localhost = password (' admin10000.com ');
The above example changes the user root password to admin10000.com

Method 2: Use Mysqladmin

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

Method 3: Edit the user table directly with update

First log in to MySQL.
mysql> use MySQL;
mysql> Update user Set Password=password (' admin10000.com ') 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 ("admin10000.com") where user= "root"; (don't forget the last semicolon).
7. Refresh permissions (required steps): flush privileges;.
8. Quit quit.
9. Log out of the system, then enter, using the username root and the new password just set admin10000.com login.

Several ways MySQL modifies the root password