mariaDB, centOS 설치 및 설정

$ vi /etc/yum.repos.d/MariaDB.repo
---
"# MariaDB 10.1 CentOS repository list
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1"
---

$ yum install -y MariaDB-server MariaDB-client
$ yum clean all
$ rpm --rebuilddb
$ yum update
$ yum install -y epel-release
$ rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
$ service mysql status
$ service mysql start
$ mysql -uroot -p
mysql> use mysql;
mysql> update user set password=password('비밀번호') where user='root';
mysql> flush privileges;
mysql> use mysql;
mysql> create database external;
mysql> grant all privileges on external.* to external@localhost identified by 'external';
mysql> flush privileges;
mysql> quit;
mysql> INSERT INTO mysql.user (host,user,password) VALUES ('172.27.0.104','external',password('external'));
mysql> GRANT ALL PRIVILEGES ON *.* TO 'external'@'172.27.0.104';
FLUSH PRIVILEGES;