MariaDB SQL 설치 | 데이터카페

1.다운로드 주소 
command
 - https://mariadb.org/download/?t=repo-config&d=Red+Hat+Enterprise+Linux+8&v=11.0+%5BRC%5D&r_m=blendbyte


2.reopsitories 추가
command
vi /etc/yum.repos.d/MariaDB.repo


command
# MariaDB 11.0 [RC] RedHatEnterpriseLinux repository list - created 2023-05-27 08:13 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 det
# baseurl = https://rpm.mariadb.org/11.0/rhel/$releasever/$basearch
baseurl = https://tw1.mirror.blendbyte.net/mariadb/yum/11.0/rhel/$releasever/$basearch
module_hotfixes = 1
# gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB
gpgkey = https://tw1.mirror.blendbyte.net/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck = 1


3. install 방법
command
sudo yum install MariaDB-server


4.설정 방법 
command
vi /etc/my.cnf


command
[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
event_scheduler = on

mariadb-secure-installation