Selecting a MySQL database using the mysql client tool
mysql -u root -p
USE database_name;MySQL CREATE DATABASE statement
CREATE DATABASE [IF NOT EXISTS] database_name
[CHARACTER SET charset_name]
[COLLATE collation_name];MySQL DROP DATABASE statement
The DROP DATABASE statement drops all tables in the database and deletes the database permanently. Therefore, you need to be very careful when using this statement.
DROP DATABASE [IF EXISTS] database_name;