Mysql：2.创建/删除Mysql数据库

命令行下创建Mysql数据库：

1.使用mysqladmin创建数据库

C:\software\mysql-5.7.9-winx64\bin> mysqladmin -u root -p create LearnDB
Enter password:**

2.登陆后创建

mysql>create database LearnDB;
Query OK, 1 row affected (0.03 sec)

命令行下删除Mysql数据库：

1.使用mysqladmin删除数据库

<pre name="code" class="html"><pre name="code" class="html">C:\software\mysql-5.7.9-winx64\bin> mysqladmin -u root -p drop LearnDB
Enter password:**

Dropping the database is potentially a very bad thing to do.Any data stored in the database will be destroyed.Do you really want to drop the 'LearnDB' database [y/N] yDatabase "LearnDB" dropped

2.登陆后删除

mysql> drop database LearnDB;
Query OK, 0 rows affected (0.09 sec)

查看创建后/删除后的数据库列表：

#<span style="font-size:12px;">创建后的数据库列表</span>
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| LearnDB            |
| mysql              |
| performance_schema |            
+--------------------+
4 rows in set (0.00 sec)

#<span style="font-size:12px;">删除后的数据库列表</span>
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)