MySQL Change root password

To modify the root user's password:

/* Login mysql*/

Mysql-uroot-p123

/* Switch Database */

Use MySQL

/* Modify the root user's password */

Update user set Password=password (' 1234 ') where user= ' root ';

———————————————————————— a broken line ————————————————————————

If you forget the root user's password, you cannot log in to MySQL, and you cannot change the password.

The first time to log in to MySQL is more troublesome:

1. Open a window, execute: mysqld--skip-grant-tables;//Safe Mode Login

2, then open a window to log mysql:mysql-u root;

3, then use the same method as above to modify the root user's password.

MySQL Change root password