Jul 8, 2024 · In this article, you will discover how to list all the databases in MySQL along with some examples. The MySQL, SHOW DATABASES is used to list the databases that are within the MySQL environment. It prints all the databases including the default system databases.

In this tutorial, you will learn to list databases in the MySQL database server using the MySQL SHOW DATABASES command.

SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. SHOW SCHEMAS is a synonym for SHOW DATABASES. The LIKE clause, if present, indicates which database names to match.

You can list all the databases available in the MySQL server without logging into the MySQL server from the command line itself using the -e flag followed by the SHOW DATABASES command. This is especially useful when you want to …

Jun 21, 2019 · The most common way to get a list of the MySQL databases is by using the mysql client to connect to the MySQL server and run the SHOW DATABASES command. Access the MySQL server using the following command and enter your MySQL user password when prompted: If you haven’t set a password for your MySQL user you can omit the -p switch.

Learn how to use the MySQL SHOW DATABASES statement to retrieve a list of databases on your MySQL server. Understand its syntax and practical examples for effective database management.

Apr 1, 2025 · In this tutorial, we learned about the SHOW DATABASES command, which is used to fetch the names of the databases available in the MySQL server. We also saw different examples using this command and how we can apply filters using LIKE and WHERE clauses to get a filtered list of database names.

MySQL addresses this problem through several statements that provide information about the databases and tables it supports. You have previously seen SHOW DATABASES, which lists the databases managed by the server.

Sep 24, 2022 · In this tutorial, we will see how can we list all the databases in MySQL using CLI as well as the MySQL workbench. There are multiple ways you can list all the databases using CLI. We will see all the available methods out there. So, let’s get started! Also read: MySQL Show Users – A Complete Guide.

Jan 15, 2025 · The methods outlined in this article provide a range of ways to display all databases in MySQL, including using the SHOW DATABASES command, the SHOW Databases table, the mysql command, the information_schema table, and the --database option.