Set root password After installing MySQL under Windows

After the initial installation, use the administrator to enter the CMD interface,

1. Enter "Mysql-u root-p; "," Enter Password: ", direct enter
2. Enter "show databases; "And you'll see the MySQL database, and we'll switch to this database
3. Enter "use MySQL; ", switch to MySQL database
4. Enter "Update user set Password=password (' 123456 ') where user= ' root ';" To set the root user's password, which is set to 123456
5. Enter "flush privileges" to refresh the permissions
6. Enter "Quit" to sign out
7. Enter "Mysql-u root-p; "," Enter Password: ", enter the password you just set, return, login successful.

At this point, the root password has been modified successfully.

Set root password After installing MySQL under Windows