Home > Database > Mysql Tutorial > body text

Quick solution to the problem that mysql57 service suddenly disappeared (picture)

黄舟
Release: 2017-05-21 09:11:29
Original
2208 people have browsed it

The following editor will bring you a quick solution to the problem of mysql57 service suddenly disappearing. The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor and take a look.

1.

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. When entering the password, enter the password under the .err file

##Attachment:

I used mysqld -install directly before, but an error was reported when starting the service

MySQL service on the local computer Start and then stop. Some services will automatically stop when not used by other services or programs

Then mysqld--remove mysql moves the service, and then the above two steps are OK

If: ERROR 1820 (HY000): You must

reset your password using ALTER USER statement before executing this statement.

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

The above is the detailed content of Quick solution to the problem that mysql57 service suddenly disappeared (picture). For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template