opensuse tumbleweed MariaDB datadir MySQL [Warning] Can’t create test file xxx lower-test

$ sudo zypper install mariadb mariadb-client 

$ sudo systemctl start mariadb 
$ sudo systemctl enable mariadb 
$ sudo systemctl status mariadb 

查询数据库连接状态

suse-tom:/home/tom # ss -nlp | grep mysql
u_str LISTEN 0      80                          /run/mysql/mysql.sock 37788                  * 0     users:(("mysqld",pid=4775,fd=20))                               
tcp   LISTEN 0      80                                      127.0.0.1:3306             0.0.0.0:*     users:(("mysqld",pid=4775,fd=19))                               
suse-tom:/home/tom # 

https://mariadb.com/kb/en/server-system-variables/#datadir
https://mariadb.com/kb/en/what-to-do-if-mariadb-doesnt-start/#systemd
https://mariadb.com/kb/en/systemd/#configuring-access-to-home-directories

[Warning] Can’t Create Test File

由于上述报错无法打开数据库

目录权限错误

确保datadir 属于mysql:mysql /var/lib/mysql 权限为 755

$ sudo chown mysql:mysql /var/lib/mysql
$ sudo chmod 755 /var/lib/mysql

配置对主目录的访问

  由于MariaDB 的 systemd unit文件默认限制对 /home、/root 和 /run/user 的访问。此处设置使protecthome选项在mariadb上失效，然后重启即可。

sudo mkdir /etc/systemd/system/mariadb.service.d
sudo tee /etc/systemd/system/mariadb.service.d/dontprotecthome.conf <<EOF
[Service]

ProtectHome=false
EOF
sudo systemctl daemon-reload

apparmor问题

https://www.cnblogs.com/ajianbeyourself/p/4158874.html