MYSQL password change without root permission locally _ MySQL

Local users do not have the root permission to change the MYSQL password method bitsCN.com

Start CMD and stop the mysql service.

Net stop mysql

Go to the bin folder under the mysql installation directory and enter

Mysqld-nt -- skip-grant-tables

Skip password detection

Then a new cmd window is opened.

Enter mysql and press enter to enter mysql as the root user.

Use mysql

Update user set password = password ("new password") where user = "root ";

Flush privileges;

If no error message is displayed, the password can be changed successfully.

BitsCN.com