Here are a few useful MySQL commands you can run from the command line, handy if you have installed MySQL and you don't have desktop access or a graphical MySQL manager application.

First we must login

      mysql -u root -p --- (the 'root' part assumes root is your mysql username)

Create a MySQL Database

      CREATE DATABASE new_database; --- (don't forget the semicolon ; - it's really important)

Show a MySQL Database

      SHOW DATABASES;