MySQL Forums
Forum List  »  Install & Repo

Can't start MySql service after changing lower_case_table_names to 2
Posted by: Efy Tei
Date: July 19, 2018 01:51PM

Hi,

I installed MySQL version 8.0 on for Windows on win10 Home.
I want to save table names on the disk with upper case characters, so I set the "lower_case_table_names" to 2.
It took time but I found out that it's not relevant to change the setting with the UI with my workbench (8.0), I needed to change manually the value in the "C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" file.

But then after changing it to 2, the service will not start! :(

Any help will be appreciated.

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
Can't start MySql service after changing lower_case_table_names to 2
July 19, 2018 01:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.