MySQL has a variable named lower_case_table_names, which is a parameter that sets whether to distinguish case of table names.
0
Store database names and table names in uppercase and lowercase letters. The comparison of these names is also case sensitive. If the file system of the OS on which the MySQL server runs is case insensitive(eg OS X or windows), it should not be set to this value. If you set this value to 0 on such a file system and access the MyISAM table name by mixing case, sometimes the index may be destroyed.
1
Everything is rounded to lowercase when storing table names and database names. The comparison of names is case insensitive.
2
When storing the table name and database name, store it as it is (that is, store it-while preserving upper case letters and lower case letters). When looking up, these names are converted to lowercase letters, and comparison of names is done without distinguishing uppercase and lowercase letters. Note that this function work only on file systems that do not distinguish between uppercase and lowercase letters. The table name of InnoDB is stored in all lowercase letters as when setting lower_case_table_names = 1.
[vagrant@localhost ~]$ cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock character_set_server=utf8 default-storage-engine=InnoDB innodb_file_per_table # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used (fedora >= 15). # If you need to run mysqld under a different user or group, # customize your systemd unit file for mysqld according to the # instructions in http://fedoraproject.org/wiki/Systemd user=mysql # Semisynchronous Replication # http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html # uncomment next line on MASTER ;plugin-load=rpl_semi_sync_master=semisync_master.so # uncomment next line on SLAVE ;plugin-load=rpl_semi_sync_slave=semisync_slave.so # Others options for Semisynchronous Replication ;rpl_semi_sync_master_enabled=1 ;rpl_semi_sync_master_timeout=10 ;rpl_semi_sync_slave_enabled=1 # http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html ;performance_schema [mysql] default-character-set=utf8
ないですね、ということはmy.cnfに追加できるってことかな。。
