current position:Home>Net start MySQL when starting the service, it displays' MySQL service is starting. MySQL service cannot be started. No error is reported

Net start MySQL when starting the service, it displays' MySQL service is starting. MySQL service cannot be started. No error is reported

2022-01-26 23:19:11 Winton-H

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

 

 

copyright notice
author[Winton-H],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/01/202201262319098891.html

Random recommended