MySQL Forget root password solution and 10061 Solutions

Source: Internet
Author: User
Tags ini

If you forget the MySQL root password, you can reset it in the following ways:

1. Kill off the MySQL process in the system;

2. Use the following command to start MySQL, to do not check the permissions of the way to start;

Mysqld_safe-skip-grant-tables &

3. Then use the null password method to log in to MySQL with root user;

Mysql-u Root

4. Change the password of root user;

mysql> Update Mysql.user Set Password=password (' New password ') where user= ' root ';

mysql> flush Privileges;

Mysql> quit

5. Restart MySQL, you can log in with the new password.

Can ' t connect to the MySQL server on ' localhost ' (10061) solution,

1 first check that the MySQL service does not start if it is not started, start the service.

2 Solutions:

The first step is to delete the my.ini below c:windowns

Step two, open C:mysqlbinwinmysqladmin.exe enter username and password

The third step in the DOS input mysqld-nt-remove Delete service, in the next input Mysqld-nt-install

Step Fourth enter MySQL to start successfully.

3 Other methods to refer to:

1. Look at the Hosts file localhost is not pointing 127.0.0.1

2. If the MySQL service is not started, you can run net start MySQL.

3. Some related orders:

Mysqld-nt--install #启动Mysql

MySQL #运行Mysql

Mysql-h Ipaddress-u Username-p

Or: Directly to the bin point Mysqld.exe or Mysqld-nt.exe, see if its process can run normally, if not, then to Control Panel, service to start it, see what is wrong. If not, in addition to delete the deletion of MySQL, and then reload MySQL, generally can solve the problem, you can back up the data before installation.

4 cannot connect to the MySQL server, as possible:

1, the MySQL service does not start, generally in the case of the exception of MySQL can not start, such as no available disk space, My.ini mysql basedir path set error, etc.

2, the MySQL server resource is tight, causes cannot connect.

Workaround:

1, if you are a virtual host user (buy space), then contact space to check whether MySQL normal startup, and confirm MySQL configuration information (whether for localhost);

2, if you are a stand-alone host user (with administrative host permissions), then follow the steps below to check:

1 Check disk space for remaining free space and try to keep enough disk space available.

2 Check the My.ini basedir (MySQL installation address) and DataDir (data directory storage address) and other parameters set is correct, and then restart the MySQL service.

Another way is to put the server's Windows patches.

Microsoft September 9 released the TCP/IP update patch (KB967723), if the server turned on Automatic Updates or have automatic Update software download updated this patch, then this problem will occur.

One might ask, why does the patch 9th appear, only to find the problem now?

As we all know, the server is not restarted every day, some servers may be one months or Yinianbanzai reboot once, and some may be restarted after September 9 server, so the patch is effective (I personally think so).

Patch Uninstall Method: Login to the server, access to the Control Panel---Add and Remove Programs-(check above "Show updates")

In the inside can see the updated KB967723 this patch, and then want to uninstall ordinary software like uninstall, uninstall will prompt you, if uninstall may cause the program to run error, it does not matter, choose "yes", continue to uninstall.

Uninstall completes after the program server, everything is OK!

As for the patch to repair what vulnerabilities, uninstall will appear after the server security risks, this is not to say, to MySQL normal operation, the temporary solution is the only way.

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.