What about MySQL losing the root password?

Mysql

Author: Wang Mei (HeartIcy@163.com)

The loss of the password is very distressing things, especially the root password lost: (. Install yourself
Play lost also lost, but in the event of a production server hanging trouble can be big!

Now assume that the root password was lost because of the intrusion. Here, I'll talk about myself.
Views on such a question.

First of all, we do not need to panic, the whole recovery process is very simple.

1 download MySQL source distribution, do not differentiate the operating system, we need something is a
Kind of.
2 Rename your MySQL folder under the data directory for Oldmysql.
3 Copy the MySQL directory under the data directory in the source package to your MySQL data directory
Under
4 restart MySQL, now MySQL's licensing relationship with the new installation of the same, empty
Code landing, and then adjust their authorization.
5 Open Oldmysql This library to check what's going on.
6 If there is a backup of the system in the central database integrity testing to avoid being repaired
Change.

With these 6 steps you can fully restore your control of MySQL, with the focus on the
The latter two steps check each other's permissions, and the integrity of the data detected.