MySQL service is starting MySQL service failed to start

“MySQL The service is starting . MySQL Service failed to start . The service did not report any errors .” Solutions for
It's probably the homework copied from several bosses …
1. Check the source of the error
command ：mysqld --console
And then according to the different results printed out to the right medicine
1） come from koloumi Big guy's solution
Original address ：https://blog.csdn.net/koloumi/article/details/83117497
Core error reporting statement ：2018-10-17T12:35:16.439025Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
The explanation is the problem of port , Then go directly to the port to find a solution to the problem
Input netstat -aon|findstr “3306” Go to find the occupied 3306 Port process id
Then open the task manager To find the process just seen in detail id, close .

2） come from Autumncow Big guy's solution
Original address ：https://blog.csdn.net/Autumncow/article/details/79469416
Core error ： [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
It means that there is a problem with the original installation … Now , Just initialize …

Why initialize ？ So I turned to an answer , Is from sakuraRed The bosses
Original address ：http://www.cnblogs.com/RedCoral/p/7976150.html
The problem lies in one data Folder , Compare the new version of MySQL There is no such folder , So you can do this ：
mysqld --initialize-insecure（ First in mysql Of bin Execute under directory mysqld --initialize-insecure （ Not set up root password , It is recommended to use ） command , The first execution of this command takes a little longer , And the console doesn't return any results . You can see mysql There will be one more data Folder , It's a pile of papers .）
（ The above is the old man's original words ）
Then start net start mysql
Um. , This is a perfect start
Enter for the first time , Will prompt , Your password is empty
therefore ：mysql -u root -p
With this command .

P.S. Go directly to a folder
1. Enter directly above the file explorer cmd And then go back
2. Assign the address above the file explorer , then cd /d That string of addresses

（ If it helps you , Just like the collection comments for a wave ~）