mariaDB 설치

• MariaDB 설치

vi /etc/yum.repos.d/MariaDB.repo

 

- MariaDB.repo

# MariaDB 10.6 CentOS repository list - created 2023-08-07 03:53 UTC
# https://mariadb.org/download/
[mariadb]
name = MariaDB
# rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# baseurl = https://rpm.mariadb.org/10.6/centos/$releasever/$basearch
baseurl = https://mirrors.xtom.jp/mariadb/yum/10.6/centos/$releasever/$basearch
module_hotfixes = 1
# gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB
gpgkey = https://mirrors.xtom.jp/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck = 1

sudo yum install MariaDB-server MariaDB-client

 

• MariaDB 실행  # 비번 1234

systemctl start mariadb.service 
systemctl enable mariadb.service
mysql -u root -p

• redmine database 만들기

CREATE DATABASE redmine CHARACTER SET utf8 COLLATE utf8_general_ci; 
CREATE USER 'redmine'@'%' IDENTIFIED BY '1111'; 
GRANT ALL PRIVILEGES ON redmine.* TO 'redmine'@'%'; 

show databases; 
exit

• redmine database 만들기 # 위에서 설정한 비번입력

mysql -u root -p

 

• 외부접속 권한부여

GRANT ALL ON redmine.* TO redmine@'localhost' IDENTIFIED BY '1111';
exit