Reset the msyql Database root Password and msyql Database root Password

Reset the msyql Database root Password and msyql Database root Password

Password resetting method:

 

The specific method is:

1. Find the my. ini configuration file in the installation directory and open the configuration file,

Find the [mysqld] line, add skip-grant-tables below, and save the file

Restart the mysql dynamic service;

 

2. Then execute mysql-u root mysql in the mysql cmdline,

Mysql> use mysql

Mysql> update user set password = password ('newpassword') where user = 'root ';

 

Mysql> Flush privileges;

 

3. Remove the line added to my. ini configuration file and restart mysql.