Reproduced in: https://blog.csdn.net/yuer_xiao/article/details/79236719
XAMPP, which was just installed yesterday, has been tested and MYSQL can be started. Then today when I was running XAMPP, I suddenly realized that MYSQL couldn’t start.
Use the administrator to start the command line, enter net Start mysql, also did not succeed, the prompt message is
The service name is not valid. Please type NET HELPING 2185 for more help
1. Add one in mysql/bin/my.ini file:
[mysqld]
innodb_force_recovery = 4
2. Delete the IBDATa1 file under xAMPP \mysql\ Data
3. Start the command line with the administrator, enter the bin directory of mysql, and input
Mysqld –install, enter,
1. Service Successfully Installed,
Indicates successful installation of MySQL service.
Command line window input: Net Start mysql, can start normally.
The procedure is this procedure but I have already succeeded in this screenshot, so it is a little different from what I said.
The mysql service should start without any problems.
4. Or restart the command line with the administrator and reinstall XAMPP
Enter SC DELETE mysql
Remove mysql service
Reinstall XAMPP
You can use it normally
Read More:
- [xampp] error: Apache shutdown unexpected. 11:00:50 [Apache] solution details
- Restart and shutdown of Ubuntu system in the terminal
- IIS + Django project reported an error. The fastcgi process exited unexpectedly
- Kafka reported error shutdown broker because all log dirs in… Have failed
- Remote sshd prompt: server unexpectedly closed network connection
- The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
- Failed connect to github.com:443 ; no error and the remote end hung up unexpectedly
- After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
- Swift fatal error: unexpectedly found nil while unwrapping an Optional value?
- Oracle database file is damaged, Error:ORA-01033 :ORACLE initialization or shutdown in progress
- IOFileUploadException: Processing of multipart/form-data request failed. Stream ended unexpectedly
- [Solved] IE Browser Upload Files Error: org.apache.tomcat.util.http.fileupload.FileUploadException: Stream ended unexpectedly
- Question: cannot create windows service for mysql.error : 0 (install MySQL)
- Forced shutdown of VMware wrokstation error (failed to get exclusive lock on the configuration file —)
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- MySQL error set: failed to start mysql.service : Unit mysql.service is masked.
- [solution] install youcompleteme through VIM plug-in manager VIM plug, including ycmd server shutdown solution
- It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
- Swift Error fatal error: unexpectedly found nil while unwrapping an Optional value
- MySQL uses net start MySQL startup prompt (failed to start, the service did not report any error)