Config database

At the command line, log into your DBMS, as in the following example for MySQL.

mysql -u root -p

At the mysql command prompt, create a database.

create database recordings;

Change to the database you just created so you can add tables.

use recordings;

From the mysql command prompt, run the script create-tables.sql

source /path/to/create-tables.sql

At your DBMS command prompt, use a SELECT statement to verify you’ve successfully created the table with data.

select * from album;