Restore the MySQL administrator password in Linux. 1. Send the kill command to mysqldserver to disable mysqldserver (not kill-9). The files that store the process ID are usually stored in MYSQL.
Restore the MySQL administrator password in Linux. 1. Send the kill command to mysqld server to turn off mysqld server (not kill-9). The files that store process IDs are usually stored in MYSQL.
Restore the MySQL administrator password in Linux
1. Send the kill command to the mysqld server to disable the mysqld server (not kill-9). files storing process IDs are usually stored in the directory/var/lib/MYSQL of the mysql database.
# Killall-TERM mysqld
2. Use the -- skip-grant-tables parameter to start mysqld.
#/Usr/bin/safe_mysqld -- skip-grant-tables
Paths may not be the same. You can use locate to find them.
3. Then, you can log on to the mysqld server without a password. At this time, the Mysql password is the same as that at the time of installation and is empty. Now we can use mysqladmin to change the mysql password.
# Mysqladmin-u root-p password newpassword
4. Load the permission table and use the following command
# Mysqladmin flush-privileges