Create, Delete, and List Databases in MySQL

Below are some useful commands to manage users in MySQL:

Create Database

The following command will create a new database

CREATE DATABASE newdatabasename;

Delete / Drop Database

The following command will create a new database

DROP DATABASE newdatabasename;

List Databases

Run the following command to show a list of all databases

SHOW DATABASES;