Maria DB install & user & DB

# option
yum -y update

# create MariaDB YUM repos file
# https://downloads.mariadb.org/mariadb/repositories/#mirror=kaist
/etc/yum.repos.d/MariaDB55.repo

※ cat /etc/centos-release ( centos version )

# install
yum -y install mysql-server mysql

# mysql command
service mysql stop
service mysql start

# root password init
mysql -u root mysql

MariaDB [mysql]> update user set password=password('input_password') where user='root';
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> quit

# DB 생성
MariaDB [mysql]> create database db_name character set utf8 collate utf8_unicode_ci;
※ db_name 소문자로...
※ lower_case_table_names
   ( https://mariadb.com/kb/en/mariadb/server-system-variables/ )

# User 생성
MariaDB [mysql]> CREATE USER 'dbuser'@'%' IDENTIFIED BY 'dbuserpassword';
MariaDB [mysql]> grant all privileges on db_name .* to 'dbuser'@'localhost' identified by 'dbuserpassword' with grant option;
MariaDB [mysql]> flush privileges;

# charset setting
[mysql]
default-character-set=utf8

[mysqld]

collation-server = utf8_unicode_ci

init-connect='SET NAMES utf8'

character-set-server = utf8

※ refs

Installing MariaDB with yum ( https://mariadb.com/kb/en/mariadb/yum/ )
Changing the default character set to UTF-8 (https://mariadb.com/kb/en/mariadb/setting-character-sets-and-collations/)