MySQL view all MySQL databases on MySQL server

This article describes how to see what MySQL databases are on the current server when we log on to a MySQL server? The order is show databases.

How to log on to the MySQL server, and how to use the MySQL command line, we have in front of some articles have been introduced, welcome to see!

Now let's see, when we've logged on to the MySQL server, want to see what MySQL database is on the current MySQL server? And look at the order.

The order here is "show databases;"

The code is as follows	Copy Code
mysql> show databases; +--------------------+ | Database | +--------------------+ | Information_schema | | MySQL | | Performance_schema | | Test | +--------------------+ 4 rows in Set (0.08 sec)

From the above input results, a total of four databases in the database, respectively, INFORMATION_SCHEMA, MySQL, Performance_schema, test.

With this important information, we can find a way to switch to the various databases to perform specific operations.
 
about using show databases to view all MySQL databases on the MySQL server, this article introduces so many, I hope to help you, thank you!