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
If you would like a service but do not have enough of a budget, earn points through our affiliate program by referring customers to us and use them toward your project or service with us.
Have any questions?
Use the following form to submit them or call us at 917.558.8139 within US or +1 917 558 81 39 (International).
GEORGE
Sales & marketing
ALEX
Sales & marketing
GREG
Senior developer
Use the form below and ask your questions