mariadb 10.5 설치

MariaDB 10.5 설치하기

 

1. 원하는 버전 선택 후에 repo 복사

repository 추가

sudo vim /etc/yum/repos.d/MaraiDB.repo

# MariaDB 10.5 CentOS repository list - created 2021-03-16 03:20 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.5/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

 

2. 설치

sudo yum install -y MariaDB-server MariaDB-client

 

3. 실행

sudo systemctl start mysql

 

4. 자동 실행 설정

sudo systemctl enable mariadb

 

5. 접속 테스트

sudo mysql -u root -p

 

6. 캐릭터셋 설정

sudo systemctl stop mysqld

sudo vim /etc/my.cnf

내용 추가

[mysqld]
default_storage_engine=innodb
init-connect='SET NAMES utf8mb4'
lower_case_table_names=1
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

[client]
port=3306
default-character-set = utf8mb4

[mysqldump]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

재시작

sudo systemctl start mysqld

database 접속 후에 확인

show variables like 'c%';