• 创建数据库：create Database database_name

mysql> create Database test2;Query OK, 1 row affected (0.00 sec)mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || sys || test || test2  |+--------------------+6 rows in set (0.00 sec)

• 查看数据库：show databases;

mysql> create Database test2;Query OK, 1 row affected (0.00 sec)mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || sys || test || test2 |+--------------------+6 rows in set (0.00 sec)

• 选择数据库：use database_name

mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || sys || test || test2 |+--------------------+6 rows in set (0.00 sec)mysql> use information_schema;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changed #表示选择数据库成功

• 删除数据库：DROP DATABASE database_name

mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || sys || test || test2 |+--------------------+6 rows in set (0.00 sec)mysql> drop database test;Query OK, 0 rows affected (0.00 sec)mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || sys || test2 |+--------------------+5 rows in set (0.00 sec)

• 查询默认存储引擎：SHOW VARIABLES LIKE ‘storage_engine%‘;

mysql> show variables like ‘storage_engine%‘;Empty set (0.01 sec)