Why my tables’ names are converted into lowercase in phpmyadmin?

I am using wamp server 2.0 on Windows XP. Whenever I create a table with some uppercases in name, it is converted to lowercase.

For example:

I create: UserInfo
phpmyadmin convert it to: userinfo

I am using ubuntu/phpmyadmin in office but this problem does exists there.

from where can I fix this. Thanks


Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

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

Method 2

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.

Method 3

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 😀

Method 4

You must find file my.ini in your mysql folder and change, or add this line:

lower_case_table_names value = 0

Method 5

You need to find file my.ini in your mysql folder and change, or add this line at bottom:

lower_case_table_names = 2

Method 6

It was not phpMyAdmin. MySQL did this.

p.s. It is a bad practice to use camelCase in databases. Use _underlines instead. 🙂

Method 7

  • Step 1: open your MySQL configuration file: [drive]xamppmysqlbinmy.ini
    or open xampp click on mysql -> config then open my.ini file
  • Step 2: Search [mysqld] for: # The MySQL server [mysqld] in my.ini file
  • Step 3: Add this :lower_case_table_names=2
  • Step 4: save the file and restart MySQL service or (Xampp)

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes
Article Rating
Notify of

Inline Feedbacks
View all comments
Would love your thoughts, please comment.x