====== 18 CentOS7 MariaDB ======

===== インストール =====
<code>
# yum install mariadb mariadb-server
</code>

===== 起動 =====

<code>
# systemctl enable mariadb.service
# systemctl start mariadb.service
</code>

===== 初期設定 =====
<code>
# mysql_secure_installation
</code>

===== 設定追加 =====
<code>
# cat /etc/my.cnf
[mysqld]
character-set-server=utf8
max_allowed_packet = 32M
</code>



===== ディレクトリ変更する場合 =====


==== エラー ====
<code>
Feb  6 17:38:56 hoge sh: 2020-02-06 17:38:56 0 [Warning] Can't create test file /home/mysql/hoge .lower-test
Feb  6 17:38:56 hoge sh: #007/usr/sbin/mysqld: Can't change dir to '/home/mysql/' (Errcode: 2 "No such file or directory")
Feb  6 17:38:56 hoge sh: 2020-02-06 17:38:56 0 [ERROR] Aborting'
</code>

==== 対応 ====

<code>
vi /usr/lib/systemd/system/mariadb.service

ProtectSystem=full
↓↓↓
ProtectSystem=off

ProtectHome=true
↓↓↓
ProtectHome=false

PrivateDevices=false
↓↓↓
PrivateDevices=true
</code>

<code>
sed -i 's/^ProtectSystem=full/ProtectSystem=off/g' /usr/lib/systemd/system/mariadb.service
sed -i 's/^ProtectHome=true/ProtectHome=false/g' /usr/lib/systemd/system/mariadb.service
sed -i 's/^PrivateDevices=false/PrivateDevices=true/g' /usr/lib/systemd/system/mariadb.service
grep '^PrivateDevices\|^ProtectHome\|^ProtectSystem' /usr/lib/systemd/system/mariadb.service
PrivateDevices=true
ProtectSystem=off
ProtectHome=false
</code>

===== 起動スクリプトのタイムアウト値 =====

=== Timeout追加 ===

<code|/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf>
[Service]
TimeoutStartSec=3600
</code>

=== systemd リロード ===


  systemctl daemon-reload

=== 確認 ===

<code>
# systemctl show mariadb -p TimeoutStartUSec
TimeoutStartUSec=1h
</code>

{{tag>CentOS7 MariaDB mysql}}