How can I view all databases in MySQL?

1 year ago
Ava Mitchell
1 minute

In MySQL, you can view all databases by using the command SHOW DATABASES. The specific steps are as follows:

  1. Open the MySQL console. You can log in to the MySQL console using the following command:
mysql -u your_username -p

Your_username is your MySQL username. You will then be prompted to enter your password.

  1. After entering the password, proceed to the MySQL console.
  2. Use the SHOW DATABASES command to view all databases. Enter the following command:
SHOW DATABASES;
  1. After executing the command, MySQL will display a list of all the databases.
bannerAds