Mysql初始化数据库报错

Question

初始化数据库错误

Error Log Beginning configuration step: Initializing Database
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 5.7.21...
Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on...
mysqld: Character set '0.0' is not a compiled character set and is not specified in the 'C:\Program Files\MySQL\MySQL Server 5.7\share\charsets\Index.xml' file
2018-04-02T09:44:47.468292Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2018-04-02T09:44:47.468337Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2018-04-02T09:44:47.468371Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-02T09:44:47.468381Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-04-02T09:44:47.469610Z 0 [ERROR] Aborting
Process for mysqld, with ID 11812, was run successfully and exited with code 1.
Failed to start process for MySQL Server 5.7.21.
Database initialization failed.
Ended configuration step: Initializing Database

Answer 1

当所选端口已在使用中时，我遇到了这个问题。更改端口(或停止该端口上的现有服务)让我可以从这里继续。