MySQL forgot root password workaround

1. Stop the MySQL service
# Kill ' Cat/var/run/mysqld/mysqld.pid '
# Pkill Mysqld
2. Start the MySQL service using the--skip-grant-tables--skip-networking option
# mysqld--skip-grant-tables--skip-networking--user=mysql
--skip-grant-tables: Skip Authorization Form authentication
--skip-networking: With the Skip authorization table option, all people can log in without a password, which is very insecure, this option does not listen to the network and prevents malicious logons.
3. No password connection to MySQL
# MySQL
4. Reset Password

Use Mysqlupdate user set Password=password ("New_pass") where user= "root";//' new_pass ' here instead of the password you want to set flush Privileges;exit

　　

MySQL forgot root password workaround