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

Editor to share with you the wamp mysql can not start the solution, I hope you will learn a lot after reading this article, let's discuss it!

The solution that mysql can not start in wamp: 1, start MySQL service by setting environment variable; 2, stop MySQL service before starting wampserver; 3, add or modify "innodb_force_recovery=1" in my.ini, and so on.

Of the three wampserver services (apache+php+MySQL), only the MySQL service cannot be enabled. Here are several solutions:

Since MySQL has been installed before, it will not be overwritten this time, but the previous MySQL is enabled when the MySQL service is enabled

1. You can start the MySQL service by setting environment variables:

MYSQL_HOME:: add path C:\ wamp64\ bin\ mysql\ mysql5.7.23

Path: add:% MYSQL_HOME%/bin

Some computers will report an error: it probably means that wampserver does not accept the modified path (transfer 2)

two。 Because of the previously installed MySQL, it will open the MySQL service, before starting wampserver, stop this service, you can!

Win+R: run, enter: services.msc, find MySQL, right-click to stop, and then you can

At this point, restart your wampserver or reinstall wampserver, and that's fine!

3. During this period, I have also tried: the following methods, netizens can try ha ~ (I didn't succeed anyway)

Open wampserver- > mysql- > my.ini, add or modify innodb_force_recovery = 1, and then restart all services

Search the system for my.ini files, and the previous my.ini files will appear, delete or rename, and then restart wamp

In the my.ini file, add: innodb_flush_method=normal, and then restart wamp

Change the port number 3306 in the my.ini and config.inc.php files (which is the default) to another 8806 (written by myself, greater than 5000)

After reading this article, I believe you have some understanding of the solution that mysql can not start in wamp. If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.