mariaDB Can't create test file /home/data/test233.lower-test 因对/home路径无使用权限

 

Jul 18 13:36:39 test233 systemd[1]: Starting MariaDB 10.4.11 database server...
Jul 18 13:36:40 test233 sh[24619]: WSREP: Failed to start mysqld for wsrep recovery: '2020-07-18 13:36:40 0 [Note] Using unique option prefix 'interactive_time' is error-prone and can break in the future. Please use the full name 'interactive_timeout' instead.
Jul 18 13:36:40 test233 sh[24619]: 2020-07-18 13:36:40 0 [Note] /usr/sbin/mysqld (mysqld 10.4.11-MariaDB) starting as process 24735 ...
Jul 18 13:36:40 test233 sh[24619]: 2020-07-18 13:36:40 0 [Warning] Can't create test file /home/data/test233.lower-test

 

mariadb 服务对 /home 路径无使用权限

修改文件

vi /usr/lib/systemd/system/mariadb.service

# Prevent accessing /home, /root and /run/user

ProtectHome=false