Table name case sensitivity issue is a common problem to hit when you are trying to port an application to use Mysql on Linux. You can set the Mysql to always store table name in lower case by setting the startup parameter lower_case_table_names=1.
You can type the following to check if the parameter is set or not:- mysqladmin -u root -p variables
If it is not set, you can set it by editing /etc/mysql/my.cnf:
sudo gedit /etc/mysql/my.cnf
In my.cnf, it should have portions like this:-
[mysqld] # # * Basic Settings #
# # * IMPORTANT # If you make changes to these settings and your system uses apparmor, you may # also need to also adjust /etc/apparmor.d/usr.sbin.mysqld. #
lower_case_table_names=1
user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking
Previous Topic
