mysql launches error 2003 and 1067 error problem resolution methods

When mysql is installed, it is often found that it cannot start normally. The most common error encountered is error 2003. The solutions are as follows:

mysqld -nt -remove

mysqld -nt -install

Restart mysql

net start mysql

You may also encounter service 1067 errors for two reasons:

(1) there is a problem with the configuration of my.ini's basedir and datadir directories, which can be modified in the following example:

basedir=d:/ MySQL5.0 /#mysql installation location
datadir=d:/ MySQL5.0 /data# data location

However, 1 will not appear this problem.

(2) this version does not support the default engine for my.ini, so look for the following text in my.ini:

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB
Change "INNODB "to "MYISAM" to read:
default-storage-engine=MYISAM

I had this problem in the first place

After modifying the file, launch mysql, net start mysql. Note that the command I'm saying 1 must be executed in the bin directory. Because that's where the mysql, mysqld, mysqladmin, and other 1 series executables are.

When there is a

The MySQL service is starting

The MySQL service started successfully

, indicating that the service started normally.

OK!