Bug #84208 unable to use latest installer on windows
Submitted: 14 Dec 2016 18:48 Modified: 22 Dec 2016 17:39
Reporter: Eric Peterson Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:8.0 OS:Windows (10 (latest updates))
Assigned to: CPU Architecture:Any

[14 Dec 2016 18:48] Eric Peterson
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
[15 Dec 2016 6:17] Chiranjeevi Battula
Hello Eric Peterson,

Thank you for the bug report.
I tried to reproduce the issue at my end using mysql-installer-community-8.0.0.0-dmr.msi but not seeing any issues with Install and upgrade.
Could you please provide step by step (exact screenshot, stack trace etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[19 Dec 2016 16:36] Eric Peterson
apology pop-up

Attachment: taking_long_time.PNG (image/png, text), 45.33 KiB.

[19 Dec 2016 16:37] Eric Peterson
C:\ProgramData\MySQL\MySQL Installer for Windows\Logs\epeterson installer.log

Attachment: Epeterson installer.log (application/octet-stream, text), 10.89 KiB.

[19 Dec 2016 16:41] Eric Peterson
Removed everything
 - C:\ProgramData\MySQL
 - C:\Program Files\MySQL
 - C:\Program Files (x86)\MySQL

Did an uninstall of MySQL and the Installer

Reboot

- installed SQLWorkBench only
- started installer again
  - now am able to see catalog
  - updated catalog
- attempt to install server only (still getting apology pop-up, see attached image and installation log file)
[20 Dec 2016 12:24] Chiranjeevi Battula
Hello Eric Peterson,

Thank you for your feedback.
This is most likely duplicate of Bug #76476, please see Bug #76476

Thanks,
Chiranjeevi.
[22 Dec 2016 17:39] Eric Peterson
So, yes there is a bug in the installer.  When the apology pop-up occurs I went to Administration -> Services, Found MySQL80, clicked on Properties.  Changed to interact with desktop, then started the Service.  All went well.

This ticket can be closed as there is a workaround, annoying but a workaround.

Eric
[18 Jul 2018 4:29] Touhidul Islam
i got an error what Eric Peterson reported as the same screen "Apply server configuration" at "initialize database". I tried 3 different windows 10 laptop. but no success. please advice. email: russel2005@gmail.com