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;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.