Net start MySQL MySQL service is starting MySQL service failed to start. The service did not report any errors.

When starting a project , I found that the items that I could run yesterday can't run today . It turned out to be mysql There is a problem with the database , The remote database is not connected . How can this be done ？ Start in admin mode dos, Input net start mysql：

Problems arise ：MySQL The service is starting . MySQL Service failed to start . The service did not report any errors .

What's going on ？

mysql Whether to install

First check mysql Version of ：

mysql -V

  No problem .

Check environment variables

Then check the configuration of environment variables , Because it was still running yesterday , Therefore, it should not be the problem of environment variable configuration .

System variables ：

User environment variable ：

  Sure enough , The configuration variables of the environment are normal .

At this point, no problem was found , Can't this problem really be solved ？ Of course not.

Inspection services

Enter your own mysql Of bin The installation directory of the file ：

My catalogue is ：

  At present bin Directory execution ：

mysqld --remove       

mysqld --install

mysqld --remove The command will replace the installed mysql Service uninstallation

mysqld --install Command to reinstall the service

Restart mysql service

net start mysql

I solved it at this point ,mysql The service can be started successfully . 

Sign in mysql, There are new problems ：

 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

This means that the login password is wrong

I don't know what to do with the password ？

Of course, there are ways . We can solve this problem by forcibly changing the password

1、 Open with super administrator cmd, Close the service

net stop mysql

 2、 Skip permission validation login mysql

mysqld --shared-memory --skip-grant-tables

3、 restart mysql service , Sign in mysql

net start mysql

mysql -u root -p

4、 Switch to mysql, Leave the password blank . 

use mysql;

update user set authentication_string='' where user='root';

flush privileges;

5、 Set encryption rules and update new password （‘’newpassword‘’ It's your new password ）

alter user 'root'@'localhost' identified by 'newpassword';

grant all privileges on *.* to "root"@'localhost';

flush privileges;

According to the changed new password Log back in mysql that will do .

thus , The problem that bothered me for several days has finally been solved .