MySQL lost the password is very sad things, especially the root password lost: (. I pretend to play lost also lost, but in case it is a server hanging trouble can be big! Now assume that the root password was lost because of the intrusion. Here I would like to talk about my own views on such a problem. 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 the same thing.
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.
4 Restart MySQL, now the MySQL licensing relationship with the new installation of the same, empty password login, and then adjust the 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 modified.
With the above 6 steps you can completely restore your control of MySQL, focusing on the last two steps to check each other's permissions, and data integrity detection.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.