MariaDB

Install

1. MariaDB 설치

2. 테이블 생성

CREATE TABLE `user` (
	`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
	`username` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
	`password` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
	`confirmpassword` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`email` VARCHAR(128) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`active` INT(11) NULL DEFAULT NULL,
	`roles` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`permissions` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci',
	`user_type` INT(10) NULL DEFAULT NULL,
	`createdate` DATE NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;

3. CentOS8에 설치

저장소 확인

$ dnf repolist

$ sudo vim /etc/yum.repos.d/mariadb.repo
[mariadb]
name = MariaDB
baseurl = https://yum.mariadb.org/10.7.3/centos8-amd64/
gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck = 1

CentOS8 EOS
MariaDB 설치

sudo sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-Linux-*
sudo sed -i 's|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g' /etc/yum.repos.d/CentOS-Linux-*
# 원복
#sudo sed -i 's/#mirrorlist/mirrorlist/g' /etc/yum.repos.d/CentOS-Linux-*
#sudo sed -i 's|baseurl=http://vault.centos.org|#baseurl=http://mirror.centos.org|g' /etc/yum.repos.d/CentOS-Linux-*
sudo dnf install mariadb-server -y   # 위의 mariadb.repo 파일 참조하는것으로 보임
#sudo dnf install mariadb -y   # 위의 mariadb.repo 파일 참조하는것으로 보임. 그리고 Client만 설치됨
sudo yum install mariadb mariadb-server

MariaDB 구동

$ sudo systemctl start mariadb
$ sudo systemctl enable mariadb
$ sudo systemctl status mariadb

MariaDB 외부오픈

# mariadb 서비스로 존재하는지 확인
sudo systemctl -t service | grep mariadb
# sudo firewall-cmd --permanent --add-service=mariadb  #실패함...3306이 보토 mysql이래서 그런것 같음.
sudo firewall-cmd --permanent --add-service=mysql
sudo firewall-cmd --reload