How to reset the administrative password in Mysql

This article shows you how to reset the management password in Mysql, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

1. Stop the running Mysql process

Killall-TERM mysqld-LINUX

You can stop the system service net stop mysql or end the process under

2. Start Mysql in safe mode

/ usr/local/mysql/bin/mysqld_safe-- skip-grant-tables &-LINUX

There are two ways to windows:

1. Enter the installation path at the command prompt: X:\. No, no, no. \ bin\ mysqld-- skip-grant-tables

2. Edit the configuration file under the installation path: X:\ etc\ my.ini add skip-grant-tables to the last line, and then start the service www.2cto.com

Third, enter and change the administrative password

Go directly to the database and the password has been restored to empty:

Use;-Select mysql database

Update user set password=password ('123') where user='root';-change the administrative password to 123

Flush privileges;-Refresh permissions table

The above is how to reset the administrative password in Mysql. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.