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