Create the Artifactory MariaDB Database

Artifactory provides a script that will execute the SQL commands you need to create your MariaDB database.

You can find the script in $JFROG_HOME/artifactory/app/misc/db/createdb/createdb_mariadb.sql .

You should review the script and modify it as needed to correspond to your specific environment.

createdb_mariadb.sql Script

CREATE DATABASE artdb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL on artdb.* TO 'artifactory'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

Once you have verified that the script is correct, you need to run it to create the database and proceed with configuring the database.

If you are running MariaDB database on a Docker container use the following script.

CREATE DATABASE artdb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL on artdb.* TO 'artifactory'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;