Command To Show Database In Mysql. If necessary connect to a remote server using an ssl connection. Open a terminal window.
Database information schema mysql 2 rows in set 0 00 sec in this sample output information schema and mysql are name of databases. If necessary connect to a remote server using an ssl connection. To list database type the following command at mysql prompot.
To show all available databases enter the following command.
Sql structured query language sql for example to list all database in the local mysql database server first login to the database server as follows. Mysql u root p enter password. Run the show databases command. Open a terminal window.