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

Question

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

score 23 · Answer 1 · answered Mar 22 '16 at 17:46

23

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.

answered Mar 22 '16 at 17:46

Alvaro Rodriguez Scelza

3,643
2
32
47

2

Using `lower_case_table_names = 0` crashed it for me too (MySQL 5.7, Windows 10). I was unable to start the service again after changing it. Using `lower_case_table_names = 2` worked – Novastorm Oct 05 '17 at 12:24
The case was the same for me WAMP64, Windows 10, `lower_case_table_names = 0` crashed MySQL 5.7.19 `lower_case_table_names = 2` worked. – Gordon Smith Aug 18 '18 at 00:51
In MySql 8.0. only 1 value works. Service crashes immediately if I use 0 or 2. I'm used standard installer for mysql – IsmailS Jun 07 '23 at 04:54

NebuSoft · Accepted Answer · 2010-04-18T00:17:23.250

22

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

edited Apr 18 '10 at 00:17

answered Apr 17 '10 at 19:26

NebuSoft

3,962
2
22
24

in which file I will set lower_case_table_names to 0. – Awan Apr 17 '10 at 19:29
1

I updated my answer to give a better link. It's a system variable that you set. The MySQL documentation can tell you how. – NebuSoft Apr 18 '10 at 00:16
10

c:/mysql/my.ini for example. but I'd go with lower_case_table_names = 2, not 0, because with 2 "table names are stored as given but compared in lowercase". – DrLightman Mar 30 '14 at 00:35
5

In Wamp go to C:\wamp\bin\mysql\mysql5.6.17\my.ini find [mysqld] and add the line: lower_case_table_names = 2 – Hernaldo Gonzalez Dec 03 '15 at 14:24
Need to restart MySql service to apply the changes in my.ini file – Paulo Dinis Dec 24 '17 at 15:00
did as directed, after adding that line, the services will not restart. – William Howley May 02 '20 at 19:42

Ahmed Bermawy · Answer 3 · 2016-03-23T10:20:16.620

7

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

edited Mar 23 '16 at 10:20

answered Jan 28 '16 at 08:54

Ahmed Bermawy

2,290
4
35
42

2

You should use lower_case_table_names = 2 when using Windows. – Marcelo Agimóvel Jan 12 '19 at 19:44

score 4 · Answer 4 · answered Dec 04 '12 at 09:07

4

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

lower_case_table_names value = 0

answered Dec 04 '12 at 09:07

czLukasss

730
8
16

Add it underneath [mysqld] on a new line. – Gordon Smith Aug 18 '18 at 00:52

score 3 · Answer 5 · answered Nov 20 '18 at 14:29

3

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

lower_case_table_names = 2

answered Nov 20 '18 at 14:29

suresh

41
5

score 3 · Answer 6 · answered Aug 15 '20 at 08:42

Step 1: open your MySQL configuration file: [drive]\xampp\mysql\bin\my.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)

score 2 · Answer 7 · edited Oct 02 '19 at 03:41

2

It was not phpMyAdmin. MySQL did this.

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

edited Oct 02 '19 at 03:41

Osh Mansor

1,232
2
20
42

answered Apr 17 '10 at 19:30

Andrey Frolov

1,534
10
19

3

because almost all databases does not make difference between lower and upper cases. – Andrey Frolov Apr 17 '10 at 20:07
I had a WordPress plugin developer who used camelCasing in their plugin tables. Are you saying that it should not be a regular practice? – Gordon Smith Aug 18 '18 at 00:53

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

7 Answers7

Linked