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/

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;

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

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: password

• Author
• Recent Posts

Follow me

Rajesh Kumar

Mentor for DevOps - DevSecOps - SRE - Cloud - Container & Micorservices at Software AG

Join my following certification courses...
- DevOps Certified Professionals (DCP)
- Site Reliability Engineering Certified Professionals (SRECP)
- Master in DevOps Engineering (MDE)
- DevSecOps Certified Professionals (DSOCP)
URL - https://www.devopsschool.com/certification/

My Linkedin - https://www.linkedin.com/in/rajeshkumarin

Follow me

Latest posts by Rajesh Kumar (see all)

• What is Mobile Virtual Network Operator? - April 18, 2024
• What is Solr? - April 17, 2024
• Difference between UBUNTU and UBUNTU PRO - April 17, 2024