Two ways to create a database under mysql

1, command creation

First log in with root user

SQL> CREATE DATABASE DATABASENAME;

2, how do you want to create a MySQL database without logging in to MySQL, and create a userbase directory in MySQL's Data directory. After connecting MySQL, show databases; you can see the UserBase library you created.

Note: Delete the database

SQL> DROP DATABASE DATABASENAME;