Connect MySQL Error: Error 2003 (hy000): Can ' t connect to MySQL server on ' localhost ' (10061)

Source: Internet
Author: User

One, the MySQL bin directory has a MySQLInstanceConfig.exe, run can create a DB instance, create an instance can also generate Windows service, set the service to start automatically

second, installed in the D-disk discuzz! opened after the above error, how should I handle?
Winmysqladmin has been started, but there is a little red dot on the three-color tree
if "error 2003:can ' t connect to MySQL server on ' localhost ' (10061)" appears, your MySQL has not started yet.
Workaround:
The first step
Remove the my.ini below c:\windowns
Step Two
Open C:\mysql\bin\winmysqladmin.exe Enter user name and password
Step three Enter mysqld-nt-remove Delete service under DOS
in the next input Mysqld-nt-install
Fourth Step enter MySQL to start successfully.
Other methods to refer to:
1. See if localhost is pointing to 127.0.0.1 in the Hosts file.
2. If the MySQL service is not started, you can run net start MySQL.
3. Some related commands:
mysqld-nt--install #启动Mysql
MySQL #运行Mysql
mysql-h ipaddress-u username-p
or: Go directly to the bin point Mysqld.exe or Mysqld-nt.exe, see if its process can run normally, if not, then go to the Control Panel, service to start it, see what is wrong. If not, you can delete MySQL from the add-in, and then reinstall MySQL, which will generally solve the problem, and backup the data before installing.
Error:can ' t connect to MySQL server on ' localhost ' (10061)
Errno.: 2003
Error Number: 2003
Problem Analysis:
Unable to connect to MySQL server, the possible scenario is:
1, the MySQL service does not start, generally in the case of abnormal MySQL can not start, such as no disk space available, My.ini mysql basedir path settings error, etc.;
2, MySQL server resources are tight, resulting in the inability to connect.
Workaround:
1. If you are a virtual host user (space purchased), contact the space provider to check if MySQL is starting normally, and confirm the MySQL configuration information (whether localhost);
2. If you are a standalone host user (with administrative host permissions), follow these steps to check:
1) Check the disk space for any 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 are set correctly, and then restart the next MySQL service.

Third, when the MySQL remote host connection via TCP/IP, error (HY000): Lost connection to MySQL server at ' reading initial communication Packe T ', System error:104.

If you are playing MySQL command directly in the Linux shell command line, can connect to MySQL smoothly, execute query statement is more normal, but if you do STOP SLAVE; Command randomly appears error (HY000): Lost connection to MySQL server during query problem. If you write the operation command to the script file and then execute the script file, it will inevitably appear Lost connection to MySQL server at ' reading initial communication packet ', System error:1 11

If there are errors in any way of remote access, it can be thought that the system has a firewall and so on, but now this strange cramp phenomenon is baffled. The last solution found is to add a start parameter to the [MYSQLD] segment inside the MY.CNF

Skip-name-resolve

Connect MySQL Error: Error 2003 (hy000): Can ' t connect to MySQL server on ' localhost ' (10061)

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.