Shulou(Shulou.com)06/01 Report--

The following brings you about how many databases mysql can have. If you are interested, take a look at this article together. I believe that after reading mysql, how many databases can have a little help for everyone.

Some small partners may not know very well, thinking that there is only one database in mysql. In fact, in addition to several databases newly created by themselves, mysql has four other databases, named information_schema, mysql, performance_schema and test.

Follow these steps to know all databases in mysql:

1. Login to MySQL Database

mysql -u root -p //Enter mysql installation directory 1

2. Show all database names

show databases;

Read the above details about how many databases mysql can have, whether there is any harvest. If you want to know more about it, you can continue to pay attention to our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.