Troubleshoot error 2003 and 1067 10061 errors for MySQL startup

MySQL installation is often found not normal boot, encountered the most error 2003 errors,

Here's how to fix it:

Mysqld-nt-remove

Mysqld-nt-install

Restart MySQL

NET START MySQL

There may also be a problem with the service 1067 error for approximately two reasons:

(1) My.ini's basedir and DataDir directory configuration is problematic and can be modified as shown in the following example:

basedir=d:/mysql5.0/#mysql安装位置
Datadir=d:/mysql5.0/data #数据存放位置

However, this problem does not normally arise.

(2) This version does not support the My.ini default engine

# The default storage engine that would be used when create new tables
Default-storage-engine=innodb

Modify "INNODB" to "MYISAM" as:

Default-storage-engine=myisam

That's the problem I had in the first place.

After modifying the file, start MySQL, net start MySQL, note that I said this command must be executed in the bin directory. Because MySQL, mysqld, mysqladmin and so on a series of executable programs are placed there.

When it appears

MySQL Service is starting

MySQL Service has started successfully

, the surface service starts normally.

It means normal.

Added: MySQL Error number 2003 can ' t connect to MySQL server on ' localhost ' (10061)

1, first to the system services (SERVICES.MSC) inside the MySQL service to find and start the MySQL service

2, to the MySQL installation directory to find Myini files, open Myini find max_connections Modify the number of connections to 1000 restart IIS with the MySQL service (I did not install IIS, this is when the site forum traffic is too large, increase the number of connections to 1000)

Cloud Habitat Small series to remind you, if you encounter this error problem, we'd better be in the process of optimization, MySQL file connection data and Windows Server file Open data is similar, resources are limited OH.