Bug #104638 MySQL Community Installer (8.0.26.0) fails to install MySQL Server 5.6.51
Submitted: 17 Aug 2021 5:08 Modified: 1 Sep 2021 22:46
Reporter: Paul Mabus Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version:8.0.26.0 OS:Windows (10 Pro)
Assigned to: CPU Architecture:x86
Tags: installation, Windows. MySQL5.6

[17 Aug 2021 5:08] Paul Mabus
Description:
The configuration for MySQL Server 5.6.51 has failed.
You can find more information about the failures in the 'Log' tab
-----------------------------------------------------------------
Log tab:

Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL56 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.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Starting the server

Attempting to start service MySQL56...
Successfully started service MySQL56.
Waiting until a connection to MySQL Server 5.6.51 can be established (with a maximum of 10 attempts)...
Retry 1: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: SSL Connection error.
Waiting 5 seconds before the next connection attempt...
Retry 2: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: SSL Connection error.
Waiting 5 seconds before the next connection attempt...
Retry 3: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: SSL Connection error.
Waiting 5 seconds before the next connection attempt...
Retry 4: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: SSL Connection error.
Waiting 5 seconds before the next connection attempt...
Retry 5: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: SSL Connection error.
Waiting 5 seconds before the next connection attempt...
Retry 6: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: SSL Connection error.
Waiting 5 seconds before the next connection attempt...
Retry 7: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: SSL Connection error.
Waiting 5 seconds before the next connection attempt...
Retry 8: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: SSL Connection error.
Waiting 5 seconds before the next connection attempt...
Retry 9: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: SSL Connection error.
Waiting 5 seconds before the next connection attempt...
Retry 10: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 0: SSL Connection error.
Failed to connect to MySQL Server 5.6.51 after 10 attempts.
Ended configuration step: Starting the server

How to repeat:
1. Download mysql-installer-community-8.0.26.0.msi
2. Run the MSI compatibility troubleshooter to runt ("test") the app
   (Properties > Compatibility > Run compatibility troubleshooter)
3. From MySQL Installer (v1.4.38.0) choose MySQL Server 5.6.51 - X64
4. Proceed through screens, set a root password, and start installing
5. Installation fails when attempting to connect to the database - see Log tab

Suggested fix:
?
[17 Aug 2021 6:38] MySQL Verification Team
Hello Paul Mabus,

Thank you for the report and feedback.
Verified as described.

regards,
Umesh
[1 Sep 2021 22:46] Jose Ramirez Ruiz
Posted by developer:
 
Hello, this issue was fixed as part of MySQL Installer 1.4.39.
To get the latest version attempt to perform a catalog update from the Main Dashboard and accept the prompt to upgrade Installer.
Remove the failed installation and attempt to install a 5.6 server. Installation and configuration should now succeeed.

Regards.