Softaculous

Topic : lower_case_table_names problem

Posted By: jlarysz on May 15, 2020, 1:47 pm

I've just installed AMPPS 3.9 on Windows 10 using the msi installer. MySQL will not start with the log message

Different lower_case_table_names settings for server ('2') and data dictionary ('1')

I have tried setting lower_case_table_names to '1' in my.ini, but then MySQL shuts itself down shortly after startup. I cannot find where to set the server value for lower_case_table_names.

What is wrong here and how can I fix it?

Posted By: xhtmlmagic on June 18, 2020, 6:31 am | Post: 1

Even worse, I've upgraded from AMPPS 3.8 and have the same error.

When I change to lower_case_table_names=1, Mysql works, but there are no existing databases, which wouldn't be a problem since I have them backed up, but when I try to import them, Mysql says no, they already exist.

How to make Mysql see the databases or start it empty so I can import them?