Thursday, February 18, 2016

[MySQL][Resolved] This server is configured with lower_case_table_names=1, which only allows lowercase characters in schema and tables names.

 
This is the warming message in MySQL Workbench shown if value of lower_case_table_names equal to Object, MySQL Workbench would convert table name which's started capital letter to all lower case letters,  for example, table name "Course" would be converted to "course".

Step 1 

If you still want to create a table started with capital letter, you can open your MySQL configuration file: [drive]\xampp\mysql\bin\my.ini ,  for example: C:\xampp\mysql\bin\my.ini:



Step 2

Search for the text "# The MySQL server" and add "lower_case_table_names = 2" below the line of [mysqlId]
lower_case_table_names = 2

Step 3

Restart  MySQL server. (I used XAMMP so Stop that and then click start MySQL)

Step 4

Reconnect your database, you will able to create a table start with capital letter without warming message if the setting applied.


Reference:

http://stackoverflow.com/questions/8550789/where-to-change-the-value-of-lower-case-table-names-2-on-windows-xampp

No comments :

Post a Comment