List MySQL databases using command line

First, you have to login into the MySQL server through this command line:

# mysql -u root -p *****

where,
-u option is for username and -p option is for the password.



Now, you can open MySQL prompt:

# mysql>

To list all databases available:

# SHOW DATABASES;

Was this answer helpful? 0 Users Found This Useful (0 Votes)