aws | ec2에 mariaDB 10.3 설치

1. user_data

cat <<EOF>> /etc/yum.repos.d/MariaDB.repo
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck = 1
EOF
yum install mariadb-server -y
systemctl enable --now mariadb

2. 로그인

# mysql

3. 외부 계정생성

> create user '${아이디}'@'%' identified by '${비밀번호}';

4. 권한 허용

> GRANT ALL PRIVILEGES ON *.* TO '${아이디}'@'%';

5. 반영

FLUSH PRIVILEGES;