How to Configure Artifactrory with MySQL Database?

Step 1 – Install and Configure mysql server

https://www.devopsschool.com/blog/how-to-install-mysql-server-and-client-on-ubuntu/
Code language: JavaScript (javascript)

Step 2 – Create a DB Username and Password and assign required access.

CREATE DATABASE artdb CHARACTER SET utf8 COLLATE utf8_bin;
CREATE USER 'artifactory'@'%' IDENTIFIED BY 'password';
GRANT ALL on artdb.* TO 'artifactory'@'%';
FLUSH PRIVILEGES;Code language: JavaScript (javascript)

Step 3 – Download mysql-connector-java-.jar driver

Download mysql driver from http://dev.mysql.com/downloads/connector/j/ to $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib

$ wget https://cdn.mysql.com/archives/mysql-connector-java-8.1/mysql-connector-j-8.1.0.zip
$ unzip mysql-connector-j-8.1.0.zip
$ cd mysql-connector-j-8.1.0
$ cp mysql-connector-j-8.1.0.jar /opt/artifactory-pro-7.23.3/var/bootstrap/artifactory/tomcat/lib
Code language: JavaScript (javascript)

Step 4 – Local system.yaml and add following entry

$ cd /opt/artifactory-pro-7.23.3
$ find . -name system.yaml
$ vi system.yaml

shared:
  database:
    type: mysql
    driver: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/artdb?characterEncoding=UTF-8&elideSetAutoCommits=true&useSSL=false
    username: artifactory
    password: passwordCode language: JavaScript (javascript)

Rajesh Kumar

I’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked at Cotocus and regularly write about technology, travel, investing, health, product reviews, and digital marketing through my various platforms.

I publish technical articles at DevOps School, travel stories at Holiday Landmark, stock market insights at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow, and SEO and digital marketing strategies at Wizbrand.