1）mysql数据库查询：show databases
MariaDB [mysql]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec)
2）数据库创建：create database test2 charset utf8;
注：charset utf8可以支持中文
MariaDB [mysql]> create database test2 charset utf8;
Query OK, 1 row affected (0.00 sec)
3） 数据库删除：drop database test2
MariaDB [mysql]> drop database test2 ;
Query OK, 0 rows affected (0.00 sec)
原文：http://www.cnblogs.com/lixiang1013/p/7290443.html