Quickly solve the problem that the mysql57 service suddenly disappeared

one,

G:\MySQL\MySQL Server 5.7\bin> mysqld --initialize

G:\MySQL\MySQL Server 5.7\bin> mysqld -install
Service successfully installed.

G:\MySQL\MySQL Server 5.7\bin>

2. Enter the password in the .err file when entering the password

appendix:

Previously, I used mysqld -install directly, but when I started the service, an error message was reported that the MySQL service on the local computer started and then stopped. Some services will automatically stop when they are not in use by other services or programs.

Then run mysqld--remove mysql to move the service, and then follow the above two steps.

If the following error message appears: ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Just SET PASSWORD = PASSWORD('new password');

The above article on how to quickly solve the problem of mysql57 service suddenly disappearing is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.