Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours scrolling social media and waste money on things we forget, but won’t spend 30 minutes a day earning certifications that can change our lives.
Master in DevOps, SRE, DevSecOps & MLOps by DevOpsSchool!

Learn from Guru Rajesh Kumar and double your salary in just one year.


Get Started Now!

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)
Subscribe
Notify of
guest
0 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments

Certification Courses

DevOpsSchool has introduced a series of professional certification courses designed to enhance your skills and expertise in cutting-edge technologies and methodologies. Whether you are aiming to excel in development, security, or operations, these certifications provide a comprehensive learning experience. Explore the following programs:

DevOps Certification, SRE Certification, and DevSecOps Certification by DevOpsSchool

Explore our DevOps Certification, SRE Certification, and DevSecOps Certification programs at DevOpsSchool. Gain the expertise needed to excel in your career with hands-on training and globally recognized certifications.

0
Would love your thoughts, please comment.x
()
x