Dos Sign in

mysql -h Server address  -u user name  -p password 
mysql -hlocalhost -uroot -proot

database

1、 Query all databases

show databases


mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

2、 Create database （"[]" Represents dispensability ）

create database < Database name > [character set  Encoding set ]


mysql> create database personal_inf;
Query OK, 1 row affected (0.00 sec)

3、 Delete database

drop database [if exists] < Database name >
if exists: Used to prevent errors when the current database does not exist 

4、 View the encoding of the current database

show create database < Database name >

mysql> show create database personal_info;
+---------------+--------------------------------------------------------------------------+
| Database      | Create Database                                                          |
+---------------+--------------------------------------------------------------------------+
| personal_info | CREATE DATABASE `personal_info` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+---------------+--------------------------------------------------------------------------+
1 row in set (0.00 sec)

5、 Modify the coding format of a single database

alter database  Database name  character set utf8

6、 Modify data name

 Method 1：CSDN, Data migration 
 Method 2： Introduction mysql, then , To this data storage location , Find the file name and modify 
 Method 3：rename database  Old name  to  New name 
( Higher versions and above don't work , There is a risk of data loss , unsafe )

7、 Using a database

use < Database name >


mysql> use personal_info
Database changed

8、 View currently used databases

select database();


mysql> select database ();
+---------------+
| database ()   |
+---------------+
| personal_info |
+---------------+
1 row in set (0.00 sec)