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

[Peter Brawley]

Didn't you read it?

Quote

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

Fix that setting in my.ini. Then follow the usual debug routine, test one thing at a time, run the server without the service to see what of any errors are still occurring by running in a cmd window ...

C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" --console

If your password really is "--secret---", add --skip-grant-tales to that cmd so once it runs cuccessfully, you can run mysql.exe client program without authentication and change your password to something that does not contain the char sequence "--", which all mysql commandline programs use.

Fix and retry till there are no more errors. Be aware that when the server runs without error in a Windows cmd window, it appears to "hang". That's not an indication that something's wrong, it's just the crazy way Windows works.

Then open a second cmd window, run mysqladmin shutdown, then in Windows rerun the installer so it can finish its work.