Under WINDOW10, mysql57 appears "stop after the MySQL57 service on the local computer starts. Some services stop automatically when they are not being used by another service or program "error
Environment: WIN10, MySQL Community Server installed mysql5.7.20.
Most of the solutions found online are mysqld --initialize-insecure --user=mysql
, but this leads to initialization.
Review the error file, note that it is not mysqld --console
.
In fact, there is an error file in the data file folder, the. err file (My is desktop-***.err under the C:\ProgramData\MySQL\MySQL Server 5.7\data folder). To view text content:
2017-11-14T03:10:560'default-character-set=utf8'
Previously, because of the reason for the encoding is added under My.ini default-character-set=utf8
, after the computer restarts, the SQLD will not be able to start SQL. Just comment it out.
It is important to note that since I set up MySQL auto-install and power-on during the installation, I need to restart the computer for it to take effect even if it is commented out. This is why there was a problem when you added this sentence without error and restarted.
Win10 "Stop after MySQL57 service on the local computer starts"