How to solve the problem that mysql cannot be started after phpstudy is installed

Cause Analysis

I went online to search for the conflict between phpstudy and mysql. Oh, it turns out that both mysql occupies the 3306 port, and the original mysql of the system will start up (right here, it will The original mysql starts monitoring as a service). Then when you open phpstudy, another mysql service will be started. At this time, because it is the same port, there will be a conflict.

There are indeed people on the Internet who have encountered the same problem as me. It is nothing more than deleting the original mysql or modifying the configuration file. Obviously this solution is not what I want. of. And it didn't successfully solve my problem.

So I wanted to try this solution. Will there be no conflict if I change the mysql port in phpstudy to 3307? I changed it. In theory, it can be successful, but it is still the same as before. The problem is not solved.

At this time, I want to uninstall mysql in phpstudy, but have I found the setting for setting the mysql path in phpstudy? If this plan doesn't work, think of another plan.

So, I thought of moving the installed mysql to the mysql directory of phpstudy, and deleting all the files in the original mysql location. Will this allow phpstudy to use the original mysql database? I tried again, but still couldn't solve the problem. Because even if the mysql run file configuration file data file is moved in this way, the service in the computer management above is still starting the mysql service in the original location, and the mysql service file path specified by this mysql service cannot be modified. This plan will not work!

Solution to the problem

Let’s change our thinking again. This time I restored all the files deleted from the original mysql directory. Now the original mysql and the mysql folder of phpstudy have the same content, as shown below:

Select Replace All when moving.

The above is the detailed content of How to solve the problem that mysql cannot be started after phpstudy is installed. For more information, please follow other related articles on the PHP Chinese website!