Make MySQL Running on Linux Case Insensitive

Background

Some users running MySQL on a Linux machine will have MySQL running as case sensitive. For CentreStack to properly access the database without any issues this setting needs to be changed to case insensitive.

You can see if this is the case by running a query like “SELECT * FROM csmain.xaf_user;”. If that does not work you can try running it as “SELECT * FROM csmain.xaf_User;” and it should display some results.

Steps to Fix

1. Locate the configuration file for MySQL. It should be located in a path similar to “/etc/mysql/my.cnf”.
2. Edit the file, set the following variable:

lower_case_table_names=1

3. Save the file.
4. Shutdown MySQL Service.
5. Restart MySQL Service.
6. Run the following query to verify the change has taken effect: “SELECT * FROM csmain.xaf_user;”