MariaDB 更改資料庫路徑

Anderson

vim /etc/my.cnf.d/server.cnf
[mysqld]
datadir                        = /home/MariaDB
character-set-server      = utf8
collation-server             = utf8_unicode_ci


vim /etc/my.cnf.d/client.cnf
[client]


vim /usr/lib/systemd/system/mariadb.service
vim /etc/systemd/system/mysqld.service



[Service]
找
ProtectHome = true
修改為
ProtectHome = false

或
sed -i 's/ProtectHome=true/ProtectHome=false/g' /usr/lib/systemd/system/mariadb.service

systemctl daemon-reload
systemctl restart mariadb

Anderson

編輯
vi  /etc/systemd/system/mariadb.service.d/override.conf

加入
[Service]
ProtectHome=false

重新啟動
systemctl daemon-reload
systemctl restart mariadb