MySQL Modify root password simple method

Using the MySQL update command, you can either modify root's old password or set the root password to be null, and if you change the root password using the update command, you need to use the Encryption function password (string) with MySQL. This function encrypts a plaintext password and is not decrypted and is used specifically for the Mysql.user (User Rights table) to set the password in the

The method to modify the root password using the update command is as follows

The code is as follows	Copy Code
mysql> use MySQL Database changed mysql> Update user Set Password=password (' 123456 ') where user= ' root '; Query OK, 0 rows Affected (0.00 sec) Rows matched:1 changed:0 warnings:0 mysql> flush Privileges; Query OK, 0 rows Affected (0.00 sec)

This happens when you know the password, and the download is modified.