mysql 安装初始化失败怎么办_MySQL 安装时走到初始化的时候失败

如图，错误Log如下Beginningconfigurationstep:WritingconfigurationfileEndedconfigurationstep:WritingconfigurationfileBeginningconfigurationstep:UpdatingWindowsFirewallrules...

如图，错误Log如下Beginning configuration step: Writing configuration fileEnded configuration step: Writing configuration fileBeginning configuration step: Updating Windows Firewall rulesAttempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 3306" protocol=TCP localport=3306已删除 1 规则。确定。Adding a Windows Firewall rule for MySQL57 on port 3306.Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow确定。Successfully added the Windows Firewall rule.Ended configuration step: Updating Windows Firewall rulesBeginning configuration step: Adjusting Windows serviceAttempting to grant Network Service require filesystem permissions.Granted permissions.Updating existing serviceExisting service updatedEnded configuration step: Adjusting Windows serviceBeginning configuration step: Initializing DatabaseAttempting to run MySQL Server with --initialize-insecure option...Starting process for MySQL Server 5.7.19...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' file2018-05-19T00:56:53.379162Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 81922018-05-19T00:56:53.394162Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 12018-05-19T00:56:53.394162Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2018-05-19T00:56:53.394162Z 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-05-19T00:56:53.426163Z 0 [ERROR] AbortingProcess for mysqld, with ID 8068, was run successfully and exited with code 1.Failed to start process for MySQL Server 5.7.19.Database initialization failed.Ended configuration step: Initializing Database

展开