Effective solution for phpStudy Apache and MySQL to start and then stop

phpStudy is very convenient to configure the PHP running environment on Windows, and it is simple and worry-free to use. When debugging the wordpress website locally, I used phpStudy to configure the environment. However, I encountered an annoying thing recently, that is, phpStudy has been running well, but suddenly the Apache and MySQL services cannot start.

Fault situation: Click Start or Restart on the phpStudy interface. Apache and MySQL will stop a few seconds after starting. The situation is the same no matter how you start or restart.

So I searched around on Baidu and found that many people have encountered this problem. I also tried various solutions: restarting the computer and deleting the website. , modify the port, run with administrator privileges, register Apache and MySQL services, and after a round, I was surprised to find that none of the methods worked! Apache and MySQL still start and stop after a while.

I searched on the official website but could not find a solution. In the end I had no choice but to come up with a trick: reinstall phpStudy2018.

After reinstalling phpStudy, it can be used normally, but the same problem reappeared after a few days of use. A lot of data has already been entered into the debugged website. If you reinstall phpStudy, you will have to work a lot, and it is impossible to reinstall every time something goes wrong. I even want to give up phpStudy and return to xampp, but I really don’t want to move the data again, it’s too troublesome. So I searched Baidu again, and this time I saw a netizen’s tip to check Apache’s error log to see what went wrong.

I opened the Apache error log, the location is: phpStudy\PHPTutorial\Apache\logs\error.log, the error message:

[Mon May 28 16:37:42.192961 2018] [core:warn] [pid 11664:tid 372] AH00098: pid file H:/phpStudy/PHPTutorial/Apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Mon May 28 16:37:42.194961 2018] [core:error] [pid 11664:tid 372] (OS 5)拒绝访问。  : AH00099: could not create H:/phpStudy/PHPTutorial/Apache/logs/httpd.pid
[Mon May 28 16:37:42.194961 2018] [core:error] [pid 11664:tid 372] AH00100: httpd.exe: could not log pid to file H:/phpStudy/PHPTutorial/Apache/logs/httpd.pid

It is obvious that the problem lies in httpd On the .pid file, the program cannot modify this file. It should be a permissions issue. I had an idea and renamed the file, then pressed the start button and found that Apache could be started, and the program automatically generated a new httpd.pid file.

Having the experience of starting Apache, I went to the MySQL folder and changed the file names one by one. Finally, I found that I only need to rename phpStudy\PHPTutorial\MySQL\data\PC.pid , MySQL can also be started.

Apache and MySQL stopped after starting and then stopped. Solution summary

Method 1: Rename or delete the following two files:

phpStudy\PHPTutorial\Apache\logs\httpd.pid
phpStudy\PHPTutorial\MySQL\data\PC.pid

Method 2: Right-click the folder PHPTutorial and select the administrator to take ownership (Related tutorial recommendations: php video tutorial)

Tip: Me It is judged that the problem of Apache and MySQL starting and then stopping is caused by permissions. The problem arises because the program does not have permission to write to the two files above. I guess taking ownership of the folder PHPTutorial can also solve the problem. Of course, this is just a guess. We have not tested whether it will be successful. I hope friends who have tested it will give feedback in the comments whether it is successful or not.

The above is the detailed content of Effective solution for phpStudy Apache and MySQL to start and then stop. For more information, please follow other related articles on the PHP Chinese website!