One 、 problem
occasionally , Input net start Mysql When starting the service
mysql>net start Mysql
Show
Mysql The service is starting
Mysql Service failed to start
The service did not report any errors
Two 、 reason
because mysql The default port is 3306, So when starting the service , If this port is occupied , Will appear as above “Mysql Service failed to start The service did not report any errors ” The situation of ,
Most of the reasons why bloggers encounter this problem are due to this situation , therefore , The solution is as follows
3、 ... and 、 terms of settlement
If the port is occupied , Then the simplest and crudest way , And the quickest way to solve it is to occupy 3306 Just finish the process , The specific steps are as follows
step ：
① Check the port , Find occupancy 3306 Port process ： Command line input netstat -aon , Find port number 3306 It's the same as PID
As shown in the figure , My occupation 3306 Corresponding to the process of the port PID by 4076
② End occupied port 3306 The process of ： Command line input taskkill /f /pid xxxx, Kill the process ,xxxx That is to say PID
example ： Above , my PID by 4076, namely taskkill /f /pid 4076
③ Be accomplished , Start the service again , Input net start Mysql
