Atitit. Process standardization---MySQL start-up troubleshooting Process Attilax Summary

Atitit. Process Standardization ---mysql troubleshooting processes that don't start up Attilax Summary

1. mysql startup log file 1

2. Console mode 1

3. Install as a service 1

3.1. Using the default profile 1

3.2. Guidance Profile 2

4. Start the service 2

1. mysqlthe boot log file

If the direct horse deflt file param is the default parameter : MySQL cannot auto search config file ...

The default log for MySQL restart is the log blackheads to a system ... .

Mysqld--help is help

Mysqld-verbose--help Displays all the parameters :

Author:: Old Wow's paw attilax Ayron, email:[email protected]

Reprint please indicate source: Http://blog.csdn.net/attilax

2. ConsoleWay

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

But the log shows that it doesn't 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 description does not start successfully:

3. Install as Service 3.1. Using the default configuration file

--install service_name

Default options is 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. Guide the 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 Brush does not recognize the install parameters .

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.

Post-Installation 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

Atitit. Process standardization---MySQL start-up troubleshooting Process Attilax Summary