Linux Administration Cookbook

How it works...

We installed MariaDB on our system and started it. As a result of that, we created several databases and associated data in the /var/lib/mysql directory:

$ ls /var/lib/mysqlaria_log.00000001 exampledb ib_logfile0 mysql performance_schemaaria_log_control ibdata1 ib_logfile1 mysql.sock

After running through the secure setup script, we then entered our database using the password we'd just set:

$ mysql -uroot -pexamplerootpassword

This dropped us into a completely different shell, one within the MariaDB program, which enabled us to manipulate the databases that MariaDB controls. 

We created a database and a table inside it after a bit of poking around:

MariaDB [mysql]> create database exampledb;MariaDB [exampledb]> create table ...