Atitit. process standardization --- Summary of the troubleshooting process attilax when mysql cannot be started, and atititattilax

Atitit. process standardization --- Summary of the troubleshooting process attilax when mysql cannot be started, and atititattilax

Atitit. process standardization-Summary of the troubleshooting process attilax when mysql cannot be started

 

1. mysql startup Log File 1

2. console mode 1

3. Install as service 1

3.1. Use the default configuration file 1

3.2. Guiding configuration file 2

4. Start Service 2

 

1. mysql startup Log File

If the trojan file param is the default parameter, mysql cannot automatically search the configuration file...

The default log for mysql restart is blacklisted in the system log ....

 

Mysqld -- help is help

Mysqld-verbose -- help displays all parameters ..

 

Author: old wow's paw Attilax iron, EMAIL: 1466519819@qq.com

Reprinted please indicate Source: http://blog.csdn.net/attilax

 

2. console mode

D: \ wamp \ bin \ mysql \ mysql5.5.20 \ bin \ mysqld.exe -- defaults-file = D: \ wamp \ bin \ mysql \ mysql5.5.20 \ my. ini

However, the log does not appear on the console.

 

D: \ wamp \ bin \ mysql \ mysql5.5.20 \ bin \ mysqld.exe -- defaults-file = D: \ wamp \ bin \ mysql \ mysql5.5.20 \ my. ini

 

 

This cmd is stuck all the time .. If you exit, the instance is not started successfully ..

 

3. Install as service 3.1. Use the default configuration file

 

-- Install service_name

Default options are read from the following files in the given order:

C: \ Windows \ my. ini C: \ Windows \ my. cnf C: \ my. ini C: \ my. cnf D: \ wamp \ bin \ mysql \ mysql5.5.20 \ my. ini D: \ wamp \ bin \ mysql \ mysql5.5.20 \ my. cnf

 

 

 

3.2. Guiding configuration file

D: \ wamp \ bin \ mysql \ mysql5.5.20 \ bin \ mysqld.exe -- install mysqlP4n -- defaults-file = D: \ wamp \ bin \ mysql \ mysql5.5.20 \ my. ini

Install parameter must first... beir click to recognize the install parameter.

 

Echo ..

C: \ Users \ Administrator> D: \ wamp \ bin \ mysql \ mysql5.5.20 \ bin \ mysqld.exe -- install

MysqlP4n -- defaults-file = D: \ wamp \ bin \ mysql \ mysql5.5.20 \ my. ini

Service successfully installed.

 

 

 

Installed services

D: \ wamp \ bin \ mysql \ mysql5.5.20 \ bin \ mysqld.exe -- defaults-file = D: \ wamp \ bin \ mysql \ mysql5.5.20 \ my. ini mysqlP4n

 

 

4. Start the service

Net start mysqlP4n