Using Command List All Databases in MySQL on the Server

In this article, we show you how to list all databases in MySQL using a command on the server. Commonly you know that MySQL is an open source relational database management system. Most of the web applications are using MySQL database e.g. Core PHP Applications, WordPress, Magento, etc.

If you like to list all your database for that you need access to run the command as root or via the sudo in your Linux server. Once you connected the server with SSH use the following steps to get the database and table names.

If you like to create a database backup using SSH. Here you have an article.

Mysql Databases List

Output:

You may be required to provide MySQL hostname, username, and password to use.

Example:

To list Database

Output:

If you want to use a particular database and you like to list all the tables in it use the following command to the list.

To list the tables use the following command.

Output:

Was this article helpful?

Yes No
×

How can we improve it?

×

We appreciate your helpul feedback!

Your answer will be used to improve our content. The more feedback you give us, the better our pages can be.

Follow us on social media:

Facebook Pinterest

Mraj

Creative Designer & Developer specialist by the spirit and a loving blogger by thoughts.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top

DON’T MISS ANY UPDATE

Get notified about the next update

Pin It on Pinterest