1. 登录数据库
mysql -h localhost -u root -p
2. 数据库基本操作
2.1 查看数据库
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+--------------------+
6 rows in set (0.00 sec)
2.2 创建数据库
mysql> CREATE DATABASE db;
mysql> CREATE DATABASE IF NOT EXISTS db;
指定字符集:
mysql> CREATE DATABASE db CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
2.3 查看创建数据库定义
mysql> SHOW CREATE DATABASE db \G;
*************************** 1. row ***************************
Database: db
Create Database: CREATE DATABASE `db` /*!40100 DEFAULT CHARACTER SET utf8 */
1 row in set (0.00 sec)</