MySQL hints can t connect to MySQL server on localhost (10061)

Source: Internet
Author: User

We know is upgraded a package to be directly deleted on the upgrade, and then Baidu know that the original is KB967723 patch caused.

Go to Control Panel-Add and Remove Programs-(check "show Updates" above) "Find KB967723 this patch, click Delete and then select"

Yes, continue with the uninstall. Program server after uninstall completes


other problem solving methods sharing, solutions (for Win system):

1, first to the system services to find MySQL services and start the MySQL service.
2, to the MySQL installation directory to find My.ini files, open My.ini find max_connections Modify the number of connections to 1000 restart IIS with MySQL service.

Under Window
At the command line, enter:

The code is as follows Copy Code

>CD E:mysqlbin
>mysqladmin-u root password your password.
>mysql-u root-p
Enter Password: your password

If it's a port error, we can access the registry.

1, start Registry Editor. (Start-run-regedit)
2, locate the following subkey in the registry, and then click Parameters:

Hkey_local_machinesystemcurrentcontrolsetservicestcpipparameters
3. Click New on the Edit menu, and then add the following registry key: Value Name: MaxUserPort
Value type: DWORD
Value data: 65534 (note is decimal)
Valid range: 5000-65534 (decimal)
Default value: 0x1388 (50,000)


Other issues

Unable to 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 the cause, such as no available disk space, My.ini MySQL

The Basedir path setting error, etc.;
2, the MySQL server resource is tight, causes cannot connect.

Workaround:
1, if you are a virtual host user (purchase space), the contact space provider to check whether MySQL normal startup, and confirm the MySQL configuration information (is

no localhost);
2, if you are a stand-alone host user (with administrative host permissions), then follow the steps below to check:
1 Check whether the MySQL service is started.
Windows host, right click on My Computer, click Manage, find the MySQL service in the service and application to see if it is in a started state.

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.