Wamp Server Error [Local Server - 2 of 3 services

问题:

I am new to wamp servers and trying to install wampServer 3.1.0 on my windows 10 machine .

Somehow it is not installed properly and is having configuration error .

At present "Wamp server is still in orange state and is throwing the error"

2 of 3 services running

As of my understanding either of Apache,MySQl orPHP is not working . On further investigation I found that Apache is ok. But on running mysql.exe(C:\wamp64\bin\mysql\mysql5.7.19\bin) it is throwing :

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

which lands me to SO-32519474 , I tried following the steps ,but it looks good to me in my case . On further searching I find that wampmysqld64 is stopped in the services. when I am trying to restart it I am getting the error

I am stuck up here and have no further clue how to get it fixed

Any help is highly appreciated.

回答1:

In my case was the Apache Service.

1. So I clicked the Wamp icon, then Apache > Service administration 'wampapache64' > Install Service.
2. Then again Wamp icon, then Apache > Service administration 'wampapache64' > Start Service.
3. And finally Wamp icon > Restart All Services.

回答2:

I got to this SOI=35670755 and executed this command

mysqld --initialize

inside (C:\wamp64\bin\mysql\mysql5.7.19\bin)

this fixed my issue.

If in case you still have issues refer to this post Wamp Server Error [Local Server - 2 of 3 services running]

**Edit:

mysqld --initialize

may not be a great solution ,its kind of patch work. It leads to issues with username and password. The best way to install xampp is completely described in the following links

Wamp Server Error [Local Server - 2 of 3 services running] & Error While Logging into MYSQL

回答3:

I faced the same issue , related to MYSQL , If in your system mysql was there, later you installed WAMP then again one MYSQL will install as WAMP package, default port for MYSQL is 3306 , So in both mysql the port will be 3306, which is a port conflict, So just change the port it will work fine. Steps to change the Port.

1. Right click the icon.
2. Chose Tool
3. Change the port in Port used by MySql Section.

回答4:

I found that WAMP can create a configuration report which details where problems lie.

Right-click on the WAMP icon, then Tools, then Create Wampserver Configuration Report (near the bottom). WAMP then opens and closes several cmd windows in generating the configuration report (wampConfReport.txt in the wamp directory).

Then again right-click on the WAMP icon, then Tools, then Wampserver Configuration Report. This will open the configuration report in your default text editor, and you can look through it to find what the problem is.

In my case I had another mysqld process listening on the port, and the report included the lines:

Your port 3307 is used by a processus with PID = 3132
The processus of PID 3132 is 'mysqld.exe' Session: Services
The service of PID 3132 for 'mysqld.exe' is 'MySQL57'
*** ERROR *** This service IS NOT from Wampserver - Should be: 'wampmysqld64' or 'wampmariadb64'

So after killing the process with PID 3132 and restarting WAMP everything worked ok.

回答5:

Check if MySQL is open, close it. Go to task manager and end process tree. Now restart wampserver. And then the MySQL (when it turns green). Hopefully it will work! As it happens, wampserver uses the same port as MySQL, therefore, the mysql service is unable to run when MySQL is running.

回答6:

Adding to the answer above:

In my case was the Apache Service.

1. So I clicked the Wamp icon, then Apache > Service administration 'wampapache64' > Install Service.
2. Then again Wamp icon, then Apache > Service administration 'wampapache64' > Start Service.
3. And finally Wamp icon > Restart All Services.

If Install Service is not working just open your task manager and see if apache is already running and if so, just end those processes and then follow the answer above.

回答7:

For me, this issue occurred when I first used WAMP 10 mins ago.

In case someone had the same issue as me, my solution was the following:

• Click the WAMP icon and simply Start All Services

worked like a charm.

回答8:

Open your MySQL log through the Wampserver icon in your taskbar. It shows the error that is preventing the service from starting. Chances are the error is due to the port being used by some other program. Now all you need to do is run MySQL on some port other than the one your computer is trying (and failing) to use. Do this by right clicking on the Wampserver icon (in your taskbar), going to MySQL and clicking on "Use a port other than __". Type in a port that is not being used by any service. Type netstat -an in your command prompt to see all the ports that are being used. Your new port should be such that it is not present here. The icon should go green now.