7.1 创建数据库

7.1　创建数据库

在MySQL中创建数据库比较简单，使用的是CREATE DATABASE语句，本节简单介绍如何在MySQL中创建数据库。

7.1.1　使用CREATE DATABASE语句创建数据库

1．语法格式

创建数据库的语法格式如下：

---

CREATE DATABASE database_name

---

2．简单示例

首先，在CentOS 6.8服务器上登录MySQL。

---

[root@binghe150 ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.18 binghe edition
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c