mysql设置数据库默认编码和表名不区分大小写

只需在my.ini中的[mysqld]组名的末尾添加：
character-set-server=utf8
重启mysql

mysql> show variables like ‘character%‘
character_set_client	        utf8
character_set_connection	utf8
character_set_database	        utf8
character_set_filesystem	binary
character_set_results   	utf8
character_set_server	        utf8
character_set_system	        utf8
character_sets_dir	/usr/share/mysql/charsets/

mysql是否区分大小写设置是由参数lower_case_table_names决定的，其中：
lower_case_table_names = 0 
区分大小写（即对表名大小写敏感）
mysql> show variables like "%case%";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | ON    |
| lower_case_table_names | 0     |
+------------------------+-------+
lower_case_table_names = 1 
不区分大小写（即对表名大小写不敏感）
mysql> show variables like "%case%";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | OFF   |
| lower_case_table_names | 1     |
+------------------------+-------+