show global variables like "lower_case_table_names"; Variable_name Value lower_case_table_names 0 create database BaR collate ascii_bin; create database Bar collate utf8_unicode_ci; show databases; Database information_schema BaR Bar mtr mysql test use BaR; create table f(i int); show create table f; Table Create Table f CREATE TABLE `f` ( `i` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci use Bar; create table f(i int); show create table f; Table Create Table f CREATE TABLE `f` ( `i` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci use test; drop database BaR; drop database Bar;