What about MySQL losing the root password?

Source: Internet
Author: User
Tags mysql
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.



Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.