MySQL localhost (10061) workaround

First step

Delete the My.ini under C:windowns

Second Step

Open C:mysqlbinwinmysqladmin.exe Enter user name and password

The third step in DOS input mysqld-nt-remove Delete Service

Then enter the Mysqld-nt-install

Step Fourth enter MySQL to start successfully.

Other methods to refer to are:

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.

Error:can ' t connect to the MySQL server on ' localhost ' (10061)

Errno.: 2003

Error Number: 2003

Problem Analysis:

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, 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.