First you must install MySQL on your local machine.
Then create the database and user via:
CREATE DATABASE tikit;
CREATE USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'password123';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%';
FLUSH PRIVILEGES;
The reason why we have to create a username with mysql_native_password is due to nodej's mysql module's antiquated authentication module. This ensures the user has the correct type of authentication.
Finally, import both tikit_events.sql
and tikit_inventory.sql