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!

You may also be interested in:

Steps to import mysql database under wampserver
How to install multiple versions of PHP, MySQL, and Apache under WampServer
Specific method to modify mysql password under dos or wamp
Solution to modify mysql access password under wamp
How to modify the default empty password of mysql in WAMP

<<: Detailed explanation of Vue options

>>: In-depth understanding of Vue's data responsiveness

A brief discussion on spaces and blank lines in HTML code

arcgis.js controls the display range of the map body to automatically bounce back when it exceeds the area (implementation ideas)

Table of contents background Effect Ideas backgro...

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

A brief discussion on spaces and blank lines in HTML code

How to use async await elegantly in JS

The process of setting up an environment for integration testing using remote Docker

Implementation steps for docker-compose to deploy etcd cluster

Which loop is the fastest in JavaScript?

Introduction to the use of html base tag target=_parent

How to use commands in Mysql to achieve hierarchical search help detailed explanation

Vue sample code for implementing two-column horizontal timeline

Solve the problem of Navicat importing database data structure sql reporting error datetime(0)

Using Apache ab to perform http performance testing

Recommend

A few things about favicon.ico (it’s best to put it in the root directory)

React encapsulates the global bullet box method

Docker installation and configuration steps for Redis image

How to implement HTML to detect that input is complete and automatically fill in the next content

Introduction to installing and configuring JDK under CentOS system

MySql fuzzy query json keyword retrieval solution example

CSS to achieve the transition animation effect of the picture when the mouse is placed on it

Install Percona Server+MySQL on CentOS 7

arcgis.js controls the display range of the map body to automatically bounce back when it exceeds the area (implementation ideas)

A brief analysis of Linux to check the firewall status and the status of the ports open to the outside world

Comment reply pop-up mask effect implementation idea compatible with ie 8/chrome/firefox

React passes parameters in several ways

Angular Cookie read and write operation code

URL representation in HTML web pages

Analysis of the difference between emits and attrs in Vue3