Create the database

Let's start by creating the database that will hold our tables. Open your preferred MySQL/MariaDB tool:

Run:

code sql

CREATE DATABASE library_db
CHARACTER SET utf8mb4
COLLATE utf8mb4_general_ci;

Now select the database:

code sql

USE library_db;

You can confirm that MySQL is using the correct database:

code sql

SELECT DATABASE();

You should see:

code text

library_db

At this point, you should have an empty database named library_db.

format_list_numbered Step 3 of 19