Bug #96359 MySQL 8.0 windows service fails to start

• Submitted: 28 Jul 2019 11:38
• Modified: 28 Jul 2019 19:16
• Reporter: Mauno Ryytty
• Status: Can't repeat
• Category: MySQL Workbench: Administration
• Severity: S1 (Critical)
• Version: 8.0
• OS: Windows
• CPU Architecture: ARM

[28 Jul 2019 11:38] Mauno Ryytty

Description:
2019-07-28 14:26:11 - Workbench will use cmd shell commands to start/stop this instance
2019-07-28 14:26:13 - Starting server...
2019-07-28 14:26:20 - Server start done.

FROM AATOS.err:
    2019-07-28T11:26:16  0  Warning] [MY-010915] [Server  '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.
    2019-07-28T11:26:16  0  System] [MY-010116] [Server  C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.17) starting as process 1092
    2019-07-28T11:26:19  0  Warning] [MY-010068] [Server  CA certificate ca.pem is self signed.
    2019-07-28T11:26:19  0  ERROR] [MY-000067] [Server  unknown variable 'mysql_firewall_mode=off'.
    2019-07-28T11:26:19  0  ERROR] [MY-010119] [Server  Aborting
    2019-07-28T11:26:20  0  System] [MY-010910] [Server  C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.17)  MySQL Community Server - GPL.
2019-07-28 14:26:24 - Checking server status...
2019-07-28 14:26:24 - Trying to connect to MySQL...
2019-07-28 14:26:24 - Lost connection to MySQL server at 'reading initial communication packet', system error: 0 (2013)
2019-07-28 14:26:24 - Assuming server is not running
2019-07-28 14:26:28 - Checking server status...
2019-07-28 14:26:28 - Trying to connect to MySQL...
2019-07-28 14:26:28 - Can't connect to MySQL server on 'localhost' (10061) (2003)
2019-07-28 14:26:28 - Assuming server is not running

How to repeat:
Try to start server on MySQL Workbench.

[28 Jul 2019 19:13] MySQL Verification Team

Server on stopped status

Attachment: 96359-stopped.png (image/png, text), 225.71 KiB.

[28 Jul 2019 19:14] MySQL Verification Team

Server on started status by WorkBench

Attachment: 96359 -started-by-WorkBench.png (image/png, text), 302.91 KiB.

[28 Jul 2019 19:16] MySQL Verification Team

Thank you for the bug report. Please see screenshots.