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 a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I have worked at Cotocus. I share tech blog at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow , and SEO strategies at Wizbrand.

Do you want to learn Quantum Computing?

Please find my social handles as below;

Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at WIZBRAND

Rajesh Kumar DailyLogs