Create and Manage a Database

Create a database. For example, execute the following SQL statement to create a database named test_db that uses utf8mb4 as the default character set:

create database test_db DEFAULT CHARACTER SET utf8mb4;

List databases by executing the following SQL statement:

show databases;

Use a database. For example, execute the following SQL statement to use database test_db:

use test_db;

Drop a datable. For example, execute the following SQL statement to drop database test_db:

drop database test_db;