このページの翻訳:
- 日本語 (ja)
- English (en)
最近の更新
Tag Cloud
このページへのアクセス
今日: 5 / 昨日: 1
総計: 846
- Dokuwiki.fl8.jp(166)
- 13 CentOS6メール設定(10)
- 02 ProFTPD(9)
- 14 rsync(9)
最近の更新
このページへのアクセス
今日: 5 / 昨日: 1
総計: 846
# yum install mariadb mariadb-server
# systemctl enable mariadb.service # systemctl start mariadb.service
# mysql_secure_installation
# cat /etc/my.cnf [mysqld] character-set-server=utf8 max_allowed_packet = 32M
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'
vi /usr/lib/systemd/system/mariadb.service
ProtectSystem=full
↓↓↓
ProtectSystem=off
ProtectHome=true
↓↓↓
ProtectHome=false
PrivateDevices=false
↓↓↓
PrivateDevices=true
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
/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
[Service] TimeoutStartSec=3600
systemctl daemon-reload