When creating tables in mysql i noticed that all my table names started with lowercase even when I namned them with an upper case.
I found that going into :
C:ProgramDataMySQLMySQL Server 8.0
Opening the my.ini file and changing the lower_case_table_names=0
Would to the trick according to this video.
After doing the above I shutdown the server, restarted the pc and when trying to start the server again Im getting the following error:
Could not connect, server may not be running. Can’t connect to MySQL server on ‘localhost’ (10061)
When I change back lower_case_table_names=1
It works again. How do I solve this?
EDIT:
Instead of going into the ini file I found I could change the property through the
Options file
Then under general tab I found lower_case_table_names and changed it to 0
But yet again same error.
Advertisement
Answer
As you can read here https://bugs.mysql.com/bug.php?id=89035
Since 8.0.5
It is now prohibited to start the server with a lower_case_table_names setting that is different from the setting used when the server was initialized. The restriction is necessary because collations used by various data dictionary table fields are based on the setting defined when the server is initialized, and restarting the server with a different setting would introduce inconsistencies with respect to how identifiers are ordered and compared.
It is prohibited to do so and results that the service won’t start.