This article mainly addresses the problem of forgetting the MySQLroot password. In actual operations, it is a headache if you forget the root password, the content of the following article is about cracking this problem. The main content of this article is described below.
I. One of the methods to restore the MySQL password
If you forget the MySQLroot password, you can reset it using the following methods:
1. KILL the MySQL process in the system;
Killall-TERM MySQLd
2. Run the following command to start MySQL without checking its permissions;
Safe_MySQLd -- skip-grant-tables &
3. Use the empty password to log on to MySQL as the root user;
MySQL-u root
4. Modify the password of the MySQLroot user;
- MySQL> update MySQL. user set password = PASSWORD ('new password') where User = 'root ';
- MySQL> flush privileges;
- MySQL> quit
Restart MySQL to log on with the new password.
Ii. MySQL password restoration method 2
It is possible that your system does not have the safe_MySQLd Program (for example, I am using the ubuntu operating system, MySQL installed with apt-get). The following method can be restored:
1. Stop MySQLd;
Sudo/etc/init. d/MySQL stop
(You may have other methods. Simply stop running MySQLd)
2. Run the following command to start MySQL without checking its permissions;
MySQLd -- skip-grant-tables &
3. Use the empty password to log on to MySQL as the root user;
- MySQL -u root
4. Modify the password of the MySQLroot user;
- MySQL> update MySQL.user set password=PASSWORD('newpassword') where User='root';
- MySQL> flush privileges;
- MySQL> quit
Restart MySQL
- /etc/init.d/MySQL restart
You can use the new password newpassword to log on.
The above content is an introduction to the solution to the MySQLroot password. I hope you will have some gains.