Home  >  Article  >  Database  >  What should I do if mysql cannot be started in wamp?

What should I do if mysql cannot be started in wamp?

藏色散人
藏色散人Original
2020-10-27 10:22:293693browse

Solution to the problem that mysql cannot be started in wamp: 1. Start the MySQL service by setting environment variables; 2. Stop the MySQL service before starting wampserver; 3. Add or modify "innodb_force_recovery" in my.ini =1" and so on.

What should I do if mysql cannot be started in wamp?

Recommendation: "mysql video tutorial"

wampserver three services (apache php MySQL) Only the MySQL service cannot be opened.

Here are several solutions:

Since MySQL has been installed before, this installation will not overwrite it. However, to open the MySQL service, you need to open the previous MySQL.

1. You can open the MySQL service by setting the environment variable:

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 is not working Accept the modified path (go to 2)
2. Because the MySQL installed before will start the MySQL service, before starting wampserver, stop this service and that’s it!

win R: Run, enter: services.msc, find MySQL, right-click to stop, you can


This time, restart your wampserver or reinstall wampserver, and that’s it! ! ! 3. During this period, I also tried: the following methods, netizens can try them~ (I didn’t succeed anyway~~)

    Open wampserver->mysql-> ;my.ini, add or modify
  • innodb_force_recovery = 1, Then restart all services
  • Search for the my.ini file in the system, the previous my.ini file will appear, delete it Or rename and then restart wamp;

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

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

The above is my solution to some problems that occurred when installing the wampserver software. If there is anything wrong, please point it out!

The above is the detailed content of What should I do if mysql cannot be started in wamp?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn