Maria DB 10.1.22 설치

1. 환경 추가

/etc/yum.repo.d/maria.repo

 

# MariaDB 10.2 CentOS repository list - created 2017-09-07 02:00 UTC

# http://downloads.mariadb.org/mariadb/repositories/

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.2/centos6-amd64

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

gpgcheck=1

 

mysql 로그인

SET PASSWORD = PASSWORD('123456');

 

update user set password=password('PQ$p6h3kTEs') where user='root';

grant all privileges on *.* to tobecold@'%' identified by 'PQ$p6h3kTEs';

grant all privileges on *.* to tobecold@'localhost' identified by 'PQ$p6h3kTEs';

 

1.1.2. mariadb user pass

alter user 'root'@'localhost' identified by 'Q$p6h3kTEs';

flush privileges;

 

3. mariadb database 사용권한

grant all privileges on tobemall.* to 'user'@'localhost';

 

4.  AWS MariaDB 설치

 yum install mysql mysql-devel mariadb-server

 

systemctl start mariadb