Mysql-initiated Error 2003 and 1067 problem resolution _MYSQL

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

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# Data Storage Location

However, this problem does not normally arise.

(2) This version does not support the My.ini default engine, looking for the following paragraph in My.ini:

# 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 you modify the file, start mysql,net start MySQL. Note that the command I am talking about 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

Indicates that the service is starting normally.

Ok!