Description:
unable to install MySQL (either 5.7 or 8.0) on Windows 10. I have a desktop and a laptop. Both have the latest updates. I downloaded the latest community installer. The installer get's to the "installing Server..." and the apology pop-up continually appears. I cancel, do a complete erasure, reboot, update catalog, and repeat. Same failure.
Contents of C:\ProgramData\MySQL\MySQL Installer for Windows\Logs\Epeterson installer.log
mysql-installer Information: 10 : Configuration file found.
mysql-installer Information: 10 : Loaded configuration.
mysql-installer Information: 10 : Installer starting up.
...
mysql-installer Information: 10 : Beginning changes for MySQL Server 8.0.0 with options REBOOT=ReallySuppress ADDLOCAL=ALL INSTALLDIR="C:\Program Files\MySQL\MySQL Server 8.0" INSTALLLOCATION="C:\Program Files\MySQL\MySQL Server 8.0" ARPINSTALLLOCATION="C:\Program Files\MySQL\MySQL Server 8.0" DATADIR="C:\ProgramData\MySQL\MySQL Server 8.0" ALLUSERS=1
...
mysql-installer Critical: 100 : Invalid value for parameter name.
...
mysql-installer Information: 10 : Advancing to next step using:
Service Name: MySQL80
Enable TCP/IP: True
Port: 3306
Enable pipe: False
Pipe name: MYSQL
Enable shared memory: False
Memory name MYSQL
mysql-installer Information: 10 : Beginning ServerConfigUserPanel.
mysql-installer Information: 10 : Adding User: eric@% as Monitor Admin
mysql-installer Information: 10 : Beginning ServerConfigServicePanel.
mysql-installer Information: 10 : Advancing to next step using:
Service Name: MySQL80
Autostart Service at boot: True
Service Account User: NT AUTHORITY\NetworkService
mysql-installer Information: 10 : Beginning ServerConfigPluginsPanel.
mysql-installer Information: 10 : Beginning ServerConfigAdvanceOptionsPanel.
mysql-installer Information: 10 : Beginning ConfigApplyPanel.
mysql-installer Information: 10 : Starting configuration of MySQL Server 8.0.0
mysql-installer Information: 10 : Attempting to create firewall rule with command: netsh.exe firewall delete portopening protocol=TCP port=3306 profile=ALL
mysql-installer Information: 10 : Adding firewall rule for MySQL80 on port 3306.
mysql-installer Information: 10 : Attempting to create firewall rule with command: netsh.exe firewall add portopening protocol=TCP port=3306 profile=ALL name=MySQL80 mode=ENABLE scope=ALL
mysql-installer Information: 10 : Successfully added firewall rule.
mysql-installer Information: 10 : Attempting to grant Network Service require filesystem permissions.
mysql-installer Information: 10 : Granted permissions.
mysql-installer Information: 10 : Adding new service
mysql-installer Information: 10 : New service added
mysql-installer Information: 10 : Deleting Data folder shipped
mysql-installer Information: 10 : Attempting to run MySQL Server with --Initialize-insecure
mysql-installer Information: 10 : Running process: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --initialize-insecure=on --console
mysql-installer Information: 10 : Waiting for the server stops: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --initialize-insecure=on --console
mysql-installer Information: 10 : 2016-12-12T19:15:37.613318Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql-installer Information: 10 : 2016-12-12T19:15:37.613529Z 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.
mysql-installer Information: 10 : 2016-12-12T19:15:38.666859Z 1 [Warning] InnoDB: New log files created, LSN=49311
mysql-installer Information: 10 : 2016-12-12T19:15:38.734003Z 1 [Warning] InnoDB: Creating foreign key constraint system tables.
mysql-installer Information: 10 : 2016-12-12T19:15:39.700093Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 5e5ef96a-c09f-11e6-a598-34e6d752820e.
mysql-installer Information: 10 : 2016-12-12T19:15:39.712105Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
mysql-installer Information: 10 : 2016-12-12T19:15:39.792439Z 4 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
mysql-installer Information: 10 : Finished initialize database
mysql-installer Information: 10 : Starting MySQL as a service
mysql-installer Verbose: 5 : 2016-12-12 11:15:45 - Attempting to start MySQL80 service.
mysql-installer Verbose: 5 : 2016-12-12 11:15:45 - Waiting for service status change to Running.
mysql-installer Information: 10 : Installer exit
How to repeat:
* update Windows 10 to latest patches
* download latest MySQL installer
* reboot
* start installer
* install workbench (optional)
* update catalog (not visible unless previous step taken)
* reboot (not needed if not doing above step)
* update catalog (not visible unless previous step taken)
* attempt to install MySQL Community Server
* cancel after you get tired of hitting "continue" on the apology pop-up
Suggested fix:
no fix found so far