Why my tables' names are converted into lowercase in phpmyadmin?
I've tried what's been suggested here, i must inform that
lower_case_table_names = 0
doesn't work in xampp, it crashes MySQL service at the moment you restart it. Yet
lower_case_table_names = 2
didn't crash, and apparently worked... at least it allowed me to insert a db with camel case.
You must find file my.ini in your mysql folder and change, or add this line:
lower_case_table_names value = 0
There is a directive for forcing table names to lower case.
You want to set the lower_case_table_names value to 0.
You can read more about it from MySQL documentation here
In windows the default value for lower_case_table_names = 1
.
You need to change or add this value to my.ini file in your mysql folder..
If this line is not found, then add it under [mysqld]
lower_case_table_names = 0
And then restart the wamp services, it will work :D