Creating a MySQL Database on UNIX

In the previous example, I created a MySQL database on Windows and found that database names are not case sensitive.

I ran the commands below on a UNIX machine and, as you might expect, MySQL database names ARE case sensitive there:

mysql> create database Andrew;

Query OK, 1 row affected (0.01 sec)

 

mysql> drop database andrew;

ERROR 1008 (HY000): Can't drop database 'andrew'; database doesn't exist

mysql> drop database Andrew;

Query OK, 0 rows affected (0.14 sec)

 

mysql>