How to solve the problem that the mysql service cannot be started?

This article will introduce how to solve the problem that the mysql service cannot be started. If your mysql cannot be started, there may be a problem with the ini file.

First, check whether the saving encoding format of your my.ini is ANSI, if not, change it to ANSI

Everyone should also pay attention to checking the suffix of the file. Once I found that the suffix of the ini file I created was actually txt.

(Generally when we modify my.ini, we cannot save it directly. Instead, we choose to save it in another directory and then replace it. When saving as, the default encoding may become UTF-8)

Everyone should also pay attention to checking the suffix of the file. Once I found that the suffix of the ini file I created was actually txt.

Then, go to the service to check the MySQL service status. If the startup failed before, the status here may be "starting" (meaning that it will usually get stuck during the startup process) Here, cannot start), not "started".

At this time, you need to go to the task manager to end a process called mysqld.exe. After the end, the mysql process will automatically stop.

Finally, restart the mysq service, you can start it through "Service"-right click, or you can start it through the cmd (note the administrator mode) command net start mysql.

Recommended related mysql video tutorials: "mysql tutorial"

The above is the detailed content of How to solve the problem that the mysql service cannot be started?. For more information, please follow other related articles on the PHP Chinese website!