How to list all available databases in MySQL

Show databases from MySQL prompt

Log in as root to your MySQL server, using the following command:

mysql -u root -ppassword

After a successful login you will be in MySQL shell. Run the following command:

SHOW DATABASES

You should see all available databases

How to display, list or show your databases without logging in to MySQL

Run the following command and you will see the list of all databases

mysqlshow -u user -ppassword

Show tables in a particular database

Add a name of the database at the end of the command above

mysqlshow -u user -ppassword databasename