Create the Artifactory MySQL Database

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

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

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

createdb.sql script

CREATE DATABASE artdb CHARACTER SET utf8 COLLATE utf8_bin;
CREATE USER 'artifactory'@'%' IDENTIFIED BY 'password';
GRANT ALL on artdb.* TO 'artifactory'@'%';
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.