Linux Administration Cookbook

Listing, creating, and selecting databases and tables

From inside your new prompt, you're now able to list the databases within MariaDB (confusing I know, but the database server (MariaDB) can have multiple databases that it manages):

MariaDB [(none)]> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema |+--------------------+3 rows in set (0.00 sec)

We want to take a look at the built-in mysql database, so let's flip to that:

MariaDB [(none)]> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changed

Once we're using this database, we can list the tables inside it:

MariaDB ...