[root@ufuso ~]# yum -y install mariadb-server　←　mariadb-serverインストール
インストール:
  mariadb-server.x86_64 1:5.5.52-1.el7                                         

依存性関連をインストールしました:
  mariadb.x86_64 1:5.5.52-1.el7       perl-DBD-MySQL.x86_64 0:4.023-5.el7 

[root@ufuso ~]# systemctl start mariadb　←　mariadb起動

[root@ufuso ~]# systemctl enable mariadb　←　mariadb自動起動設定
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.

[root@ufuso ~]# mysql -u root　←　MySQL?へログイン
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.52-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select user,host,password from mysql.user;　←　ホストの一覧表示
+------+-----------+----------+
| user | host      | password |
+------+-----------+----------+
| root | localhost |          |
| root | ufuso.org |          |
| root | 127.0.0.1 |          |
| root | ::1       |          |
|      | localhost |          |
|      | ufuso.org |          |
+------+-----------+----------+
6 rows in set (0.00 sec)

MariaDB [(none)]> set password for root@localhost=password('your-password');
　←　localhostのrootのパスワード設定
Query OK, 0 rows affected (0.02 sec)

MariaDB [(none)]> delete from mysql.user where user='';　←　ユーザーのいない（匿
名）ホストを削除
Query OK, 2 rows affected (0.07 sec)

MariaDB [(none)]> select user,host,password from mysql.user;　←　ホストの一覧表
示で変更内容を確認
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *A8760DCA46F5B4E809D1F679E2663736A884BEFE |
| root | ufuso.org |                                           |
| root | 127.0.0.1 |                                           |
| root | ::1       |                                           |
+------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]> exit　←　MySQLの終了
Bye

[root@ufuso ~]# mysql -u root -p　←　MySQLへrootでログイン
Enter password: 　←　MySQLのrootパスワード応答
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.52-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database test;　←　testという名でデータベースが作成でき
るか確認。
Query OK, 1 row affected (0.07 sec)

MariaDB [(none)]> grant all privileges on test.* to tu@localhost identified by 'password';
　←　testというデータベースに読み書き権限を持った（grant all privileges）ユーザー
tuをパスワードpasswordで設定できるか確認。
Query OK, 0 rows affected (0.40 sec)

MariaDB [(none)]> select user,host,password from mysql.user;　←　ホストの一覧表示
で変更内容を確認
+------+--------------+-------------------------------------------+
| user | host         | password                                  |
+------+--------------+-------------------------------------------+
| root | localhost    | *E8C3535F8B8516B041FE2FFBA079615EAA366120 |
| root | ufuso.dip.jp |                                           |
| root | 127.0.0.1    |                                           |
| root | ::1          |                                           |
| tu   | localhost    | *E8C3535F8B8516B041FE2FFBA079615EAA366120 |
+------+--------------+-------------------------------------------+
5 rows in set (0.00 sec)

MariaDB [(none)]> drop database test;　←　testデータベースを削除できるか確認。
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show databases;　←　データベースを削除できたか一覧表示で確認。
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.01 sec)

MariaDB [(none)]> exit　←　MySQLを終了。
Bye

[root@ufuso ~]# setsebool -P httpd_can_network_connect_db 1　←　SELinuxが有効
ならhttpd_can_network_connect_dbをonにする。1を入力してonにする方法もある(1=on、
0=offの意味)