Bug #90493 MySQL Installer cannot configure MySQL Server.
Submitted: 18 Apr 2018 11:51 Modified: 18 Apr 2018 13:21
Reporter: Руслан Мухаметшин Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:5.7.21 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: Apply Configuration, mysql installer, MYSQL SERVER

[18 Apr 2018 11:51] Руслан Мухаметшин
Description:
MySQL installer for Windows unable to initialize DB while configuring MySQL Server.

Log:
Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules
Attempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 3306" protocol=TCP localport=3306

Deleted 1 rule(s).
Ok.

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
Ok.

Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Updating existing service
Existing service updated
Ended configuration step: Adjusting Windows service

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-18T11:43:34.861131Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2018-04-18T11:43:34.861213Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2018-04-18T11:43:34.861268Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-18T11:43:34.861285Z 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-18T11:43:34.870327Z 0 [ERROR] Aborting
Process for mysqld, with ID 3464, 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

How to repeat:
Install MySQL Server through MySQL Installer and try to configure DB.
[18 Apr 2018 13:21] Chiranjeevi Battula
Hello Руслан,

Thank you for the bug report.
This is most likely duplicate of Bug #90429, please see Bug #90429

Thanks,
Chiranjeevi.