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:
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 413-776-4190 within US or +1 413 776 41 90 (International).
Use the form below and ask your questions