How to reset the management password of Mysql

When I use Mysql to reset the management password, I will inevitably forget the management password. How can this problem be solved?

Here we will first introduce a more common solution, including Windows and Linux operating systems: 1. stop the running Mysql process killall-TERM mysqld -------- in LINUX windows, you can stop the system service. net stop mysql or stop the process; 2. Start Mysql/usr/local/mysql/bin/mysqld_safe -- skip-grant-tables & ----- LINUX windows in safe mode: 1. Enter the installation path X: \ at the command prompt :\... \ Bin \ mysqld -- skip-grant-tables 2. Edit the configuration file in the installation path: X: \ etc \ my. add skip-grant-tables to the last line of ini, start the service www.2cto.com, enter the database, and change the management password to enter the database. The password has been restored to NULL: use mysql; -------------- select mysql database; update user set password = password ('000000') where user = 'root'; ---------- change the management password to 123 flush privileges; ------------- refresh the permission table
Author Gong qinghan