Shulou(Shulou.com)06/01 Report--

Today to learn php, of course, to install the running environment, phpstyudy is an integrated environment for running php, one-click installation is very friendly to beginners, and as a novice, then follow the tutorial to install the phpstudy integrated environment.

It was installed soon, uh-huh. It's really friendly to beginners. Phpmyadmin,Apache,php is directly configured and installed. Saved a lot of time.

But there is a hassle after installation, that is, after the Mysql starts, it will show that Mysql has stopped in a few seconds (this is what I have solved this problem, it should be a red box, don't mind, / hey). Rebooted many times. It still doesn't start.

At this time, not only the mysql in phpstudy cannot be started, but also my original mysql can not be started. What are we going to do? I still have a lot of data.

two。 Cause analysis

So I went to the Internet to look for the conflict between phpstudy and mysql. Oh, it turns out that both mysql occupy port 3306, and the original mysql of the system will boot (this is where the original mysql will be used as a service to boot and listen). Then when you open phpstudy, you will start another mysql service, which conflicts because it is the same port.

There are indeed people on the Internet who have encountered this problem like me, nothing more than the way to delete the original mysql or modify the configuration file, which is obviously not what I want.

three。 Solve the problem

So I want to try to solve it this way. Change the mysql port in phpstudy to 3307 is not a conflict? I changed it. Theoretically speaking, it can be successful, but it is still the same as before. Forget it. It's too much trouble. Let's find another way!

At this time, I want to uninstall the mysql in phpstudy, but have I found the setting of mysql path in phpstudy? This plan will not work. Come up with another plan.

So, I thought of moving the installed mysql to the mysql directory of phpstudy and deleting all the files where the original mysql was located, so that phpstudy could use the original mysql database. I tried again, but I still couldn't solve the problem. Because even if the mysql running file profile data file is moved, the above computer management service is still starting the mysql service in the same location, and the mysql service file path specified by the mysql service cannot be modified. This plan will not work!

Let's change our way of thinking. This time, I restored all the files deleted from the original mysql directory, so that the original mysql and phpstudy mysql folders have the same contents, as shown below:

Select replace all when moving.

To sum up, the solution is to copy all the files on the left side of the above image directly to the right side of → _ →.

Finally, let's take a successful screenshot, yeah.

At this time, the problem is solved perfectly, not only can retain the original data, achieve the coexistence of the two mysql, but also do not need to modify the configuration file, as long as ctrl+c ctr+v solves the problem.

Summary

The above is the perfect solution introduced by the editor to you that mysql can not start after phpstudy installation (no need to delete the original database, no need to change any configuration, no need to change the port) directly coexist, hope to be helpful to you, if you have any questions, please leave me a message, the editor will reply you in time!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.