MySQL commands

List all databases on the sql server.

mysql> show databases;

Creating a database:

mysql> CREATE DATABASE magento;

Deleting a database:

mysql> drop database magento;

To see all the tables in the db.

mysql> show tables;