wget http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm rpm -ihv mysql57-community-release-el7-7.noarch.rpm yum install mysql-server #service mysqld start systemctl start mysqld.service tail -f -n 200 /var/log/mysqld.log | grep pass # 2016-10-19T10:54:07.860478Z 1 [Note] A temporary password is generated for root@localhost: zTLvkmi5ja+< mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY "F4ckNySq!"; uninstall plugin validate_password; ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'
https://www.jfrog.com/confluence/display/RTF/MySQL
CREATE DATABASE artdb CHARACTER SET utf8 COLLATE utf8_bin; GRANT ALL on artdb.* TO 'artifactory'@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;
vi /opt/jfrog/artifactory/misc/db/mysql.properties vi /etc/opt/jfrog/artifactory/storage.properties
/etc/opt/jfrog/artifactory/storage.properties
type=mysql
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/artdb?characterEncoding=UTF-8&elideSetAutoCommits=true
username=artifactory
password=password
#type=derby
#url=jdbc:derby:{db.home};create=true
#driver=org.apache.derby.jdbc.EmbeddedDriver