Universal solution for MySQL failure to start under Windows system

MySQL startup error

Before installing MySQL on Windows 10, I used to execute net start mysql.

Start, and execute net stop mysql to shut down.

One day, when starting up, an error message popped up saying "MySQL service cannot be started" and "Please type NET HELPMSG 3523 for more help."

If you execute the startup command again, it will report "The service is starting or stopping, please wait a moment and try again."

Solution

There are some such questions on the Internet

• Modify the configuration file my.ini
• Delete files in the data directory
• Reinstall MySQL

And many other solutions.

The first two solutions did not solve my problem.

As for reinstalling MySQL, as far as I know, there will be many pitfalls if you install MySQL for the second time on a Windows computer that has already installed MySQL. If you don't want to bother, here's a quick way you can try.

The simplest solution

mysqld --console Command

There are two ways to start MySQL under Windows:

• Open cmd with administrator privileges and execute net start mysql.
• Open cmd with administrator privileges, enter the bin directory of the MySQL installation directory, and execute mysqld --console.

If the first startup method is unsuccessful, you can try the second method according to the steps below.

The first step is to kill the remaining MySQL processes

Before starting with the second method, kill the mysqld process first. implement

tasklist| findstr "mysql"

Check whether there is a mysqld process.

If there is a mysqld process, execute

taskkill /f /t /im mysqld.exe

Killing a process

Step 2: Start MySQL

Go to the MySQL installation directory bin and execute

mysqld --console 

This is the end of this article about the universal solution to the problem that MySQL cannot be started under Windows system. For more relevant solutions to the problem that MySQL cannot be started under Windows system, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!