Solutions to problems with MySQL forgetting the root password causing an unreachable connection

Source: Internet
Author: User

This problem has been committed twice! The second time is it tortured by the going crazy, so in just to solve the success of the time, take advantage of hot, hurriedly write down the solution to avoid recidivism! ~

The solution is as follows:

1. If the MySQL service is started, stop it: Enter the net stop MySQL under the DOS window, and if the MySQL service does not start, open the DOS window directly without typing.

2, in the current DOS window, switch to the MySQL bin directory, and then enter Mysqld-nt--skip-grant-tables;

3. Open a DOS window again, enter Mysql-u root

4. Enter the following code:

12set password=password ("new_pass"where user ="root"34

5, use the Task Manager, find the MYSQLD-NT process, end the process, if the Task manager in the process itself is the end of, then no tube ~

6, you are done ~

Solutions to problems with MySQL forgetting the root password causing an unreachable connection

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.