Solution to the problem that MySQL can be started when installed in WAMP but cannot be started after restart

After installing wamp for the first time, all services can be used normally, but after restarting wamp's icon turns yellow, and the same happens after reinstalling

Check the error log:

The error shown in the log is:

The log prompts that the error may be that port 3306 is occupied. Let's see which program occupies port 3306:

Run cmd in Windows and enter

netstat -aon|findstr "3306"

You can see that the program with pid 2092 occupies port 3306. End it.

Input command:

taskkill /f /pid 2092

After success, restart wamp and start normally!

Summarize

The above is the solution that the editor introduced to you when MySQL in WAMP can be started but cannot be started after restart. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time!