Mysql root password and 10061 _ MySQL

Source: Internet
Author: User
Mysql root password Forgot solution and 10061 solution bitsCN.com

If you forget the MySQL root password, you can reset it using the following methods:

1. KILL the MySQL process in the system;

2. run the following command to start MySQL without checking its permissions;

Mysqld_safe-skip-grant-tables &

3. use the empty password to log on to MySQL as the root user;

Mysql-u root

4. modify the password of the root user;

Mysql> update mysql. user set password = PASSWORD ('New password') where User = 'root ';

Mysql> flush privileges;

Mysql> quit

5. restart MySQL to log on with the new password.

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

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

2/solution:

Step 1 delete my. ini under c:/windowns

Step 2 open c:/mysql/bin/winmysqladmin.exe and enter the user name and password

Step 3: enter mysqld-nt-remove in dos to delete the service, and then enter mysqld-nt-install

Step 4: enter that mysql is started successfully.

3/other methods for reference:

1. check whether the localhost in the hosts file points to 127.0.0.1.

2. if the mysql service is not started, you can run net start mysql.

3. some related commands:

Mysqld-nt -- install # start Mysql

Mysql # run Mysql

Mysql-h ipAddress-u username-p

Or: directly go to the binpoint mysqld.exeor mysqld-nt.exe to check whether the process is running normally. if not, go to the control panel and start it in the service to check what is wrong. If not, delete mysql in the add/delete operation and reinstall mysql. Generally, the problem can be solved. you can back up DATA before installation.

4. unable to connect to the MySQL server. the possible situation is:

1. the MySQL service is not started. it is generally caused by the failure of MySQL to start in case of exceptions, such as no available disk space or incorrect basedir path setting of MySQL in my. ini;

2. the MySQL server cannot be connected due to insufficient resources.

Solution:

1. if you are a VM user (purchased space), contact the space provider to check whether MySQL is started normally and confirm the MySQL configuration information (whether it is localhost );

2. if you are an independent host user (with host management permissions), perform the following steps:

1) Check whether there is any available space in the disk space and try to keep enough disk space available.

2) Check whether the parameter settings of basedir (MySQL installation address) and datadir (Data Directory storage address) in my. ini are correct, and then restart the MySQL service.

Another way is to patch the server windows.

Microsoft released the TCP/IP update patch (KB967723) on September 23, September 9. if the server enables automatic updates or the software is automatically updated to download and update the patch, this problem may occur.

Some may ask why the patch on the 9th has not been detected yet?

As we all know, the server does not restart every day. some servers may restart once a month or a year or a half. some may restart the server after January 1, September 9, so the patch takes effect (I personally think so ).

Patch uninstall method: log on to the server and go to Control Panel-add and delete programs-(check "show updates" at the top ")

You can see the updated KB967723 patch in it, and uninstall it just like you want to uninstall common software. The uninstallation will prompt you. if The uninstallation may cause program running errors, it doesn't matter. select "yes ", continue uninstall.

After the uninstall is complete, the program server is running normally!

As to what vulnerabilities the patch patches fix and whether there will be server security risks after uninstalling the patch, this is the only way to solve this problem if MYSQL runs normally.

BitsCN.com

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.