Re: Failed Upgrade 5.6.39 -. 5.6.41 Now Mysql service will not start

[Steve Longmire]

No - Mysql 5.6.41 will not start. When you try to start the service changes to start pending amd then after a minute or so back to service stopped.

Here is the last portion of the end of the installer log:

mysql-installer Information: 10 : Beginning ConfigOverviewPage.
mysql-installer Information: 10 : Setting up product configuration controller for upgrade.
mysql-installer Information: 10 : Beginning ServerReconfigOptionsPanel.
mysql-installer Information: 10 : Beginning ConfigApplyPanel.
mysql-installer Information: 10 : Starting configuration of MySQL Server 5.6.41
mysql-installer Information: 10 : Attempting to run mysql_upgrade.exe
mysql-installer Information: 10 : Starting process for MySQL Server 5.6.41...
mysql-installer Information: 10 : Starting process with command: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" --console...
mysql-installer Information: 10 : Process for mysqld, with ID 10356, has been started successfully and is running.
mysql-installer Information: 10 : Unknown suffix '.' used for variable 'lower_case_table_names' (value '0.0')
mysql-installer Information: 10 : 2018-09-05 16:19:08 0 [ERROR] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Error while setting value '0.0' to 'lower_case_table_names'
mysql-installer Information: 10 : 2018-09-05 16:19:08 0 [ERROR] Aborting
mysql-installer Information: 10 : 2018-09-05 16:19:08 0 [Note] Binlog end
mysql-installer Information: 10 : Starting process with command: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql_upgrade.exe --force --host=localhost --port=3306 --user=root --password=~~secret~~...
mysql-installer Information: 10 : Looking for 'mysql.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe
mysql-installer Information: 10 : Warning: Using a password on the command line interface can be insecure.
mysql-installer Information: 10 : Looking for 'mysqlcheck.exe' as: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqlcheck.exe
mysql-installer Information: 10 : Error: Failed while fetching Server version! Could be due to unauthorized access.
mysql-installer Information: 10 :
mysql-installer Information: 10 : FATAL ERROR: Upgrade failed
mysql-installer Information: 10 :
mysql-installer Information: 10 : Process for mysql_upgrade, with ID 6260, was started successfully and exited with code 1.
mysql-installer Information: 10 : Process for MySQL Server 5.6.41 is not running.
mysql-installer Information: 10 : The mysql_upgrade.exe attempt failed. Please examine the log file for more details.
mysql-installer Information: 10 : Attempting to start service MYSQL56
mysql-installer Verbose: 5 : 9/5/2018 16:19:21 - Attempting to start MYSQL56 service.
mysql-installer Verbose: 5 : 9/5/2018 16:19:21 - Waiting for service status change to Running.
mysql-installer Information: 10 : Beginning ServerAccessPanel.
mysql-installer Critical: 100 : Unable to connect to any of the specified MySQL hosts.
mysql-installer Critical: 100 : Unable to connect to any of the specified MySQL hosts.
mysql-installer Information: 10 : Installer exit