Solution: 1. Use the administrator identity to start the cmd terminal and use the "tasklist |findstr mysql" command to display the existing mysql process; 2. Use "taskkill /F /PID to display the existing mysql process number. " command to kill the process and log in again.
The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.
About the solution of MySQL service cannot start-3534
The MySQL local service does not start (it should take a while Will it be closed automatically?), the prompt for manually starting the service is:
Try starting the terminal as an administrator and enter: net start MySQL
The system prompts that it cannot be started. I searched the information online and found that mysqld should be running in the background. There are other startup methods on the Internet, which are now provided. Here’s my solution:
1. First start the cmd terminal as an administrator;
Enter the command: tasklist |findstr mysql
to see Go to the following display
2, and then execute taskkill /F /PID 13616
to kill the process
After that, enter againnet start MySQL
You can see that the service item has been started
Summary of reasons: Unable to One of the reasons for the startup situation is that the mysql process already exists in the background, and we need to terminate it before the service item can be started normally.
In fact, the reason why I cannot start is very simple. My server has a MySQL57 service item that was automatically created during installation and a MySQL service item that I created myself. Obviously, the two cannot be started at the same time. I was The process killed is the MySQL57 service item.
Recommended learning: mysql video tutorial
The above is the detailed content of How to solve mysql 3534 failure to start. For more information, please follow other related articles on the PHP Chinese website!