[centos 7] mariadb 설치

1. repo 설정

 

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

 

[mariadb]

name=MariaDB

baseurl=http://yum.mariadb.org/10.1/centos7-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

 

 

2. 설치

 

# yum install -y MariaDB-server

 

3. DB 시작

 

# systemctl start mariadb

 

4. UTF8로 설정 변경

 

# vi /etc/my.cnf.d/clients.cnf

 

[client]

default-character-set=utf8

 

# vi /etc/my.cnf.d/server.cnf

 

[mysqld]

collation-server = utf8_general_ci

init-connect='SET NAMES utf8'

character-set-server = utf8

 

# vi /etc/my.cnf.d/mysql-clients.cnf

 

[mysql]

default-character-set=utf8

 

[mysqldump]

default-character-set=utf8

 

5. my.cnf 수정

 

# vi /etc/my.cnf

 

[mysqld]

        lower_case_table_names=1 

bind-address=0.0.0.0

event_scheduler=On

 

* 참고

lower_case_table_names=1 -> DB에서 대/소문자 구분하지 않도록 변경

bind-address=0.0.0.0      -> DB에 접근할 수 있는 IP 대역대 설정

event_scheduler=On        -> 스케줄러 기능 on

 

6. DB 재시작

 

# systemctl restart mariadb

 

7. 계정 생성

 

# mysql -u root -p    ( 최초에는 pw가 없음 )

 

* root 권한 추가

sql> use mysql;

sql> update user set password=password('1234');

sql> grant all privileges on *.* to 'root'@'localhost' identified by '1234';

sql> flush privileges;

 

* database 생성 및 계정 생성

sql> create database test;

sql> create user 'admin'@'%' identified by '1234';

sql> grant all privileges on *.* to 'admin'@'localhost' identified by '1234';

sql> flush privileges;

sql> grant all privileges on *.* to 'admin'@'%' identified by '1234';

sql> flush privileges;

sql> exit;