Creating and permissioning MySQL/MariaDB metadata database for Arcadia

By default Arcadia ships with a SQLite database to store metadata, but this is not recommended for Production deployments. If MySQL or MariaDB is an option for storing Arcadia metadata, you can use the below commands to create the Arcadia database and proper user grants so Arcadia can build and use its schema:

CREATE DATABASE arcadia DEFAULT CHARACTER SET utf8;
CREATE USER 'arcadia'@'%' IDENTIFIED BY '<password>';
GRANT ALL ON arcadia.* TO 'arcadia'@'%';

Please see our docs for more information on all the databases we support for storing Arcadia related metadata and artifacts.