MariaDB更新后无法启动:[警告]无法创建测试文件/home/mysql/beta.lower-test [英] MariaDB cannot start after update: [Warning] Can't create test file /home/mysql/beta.lower-test
问题描述
我刚刚使用apt-get dist-upgrade更新了MariaDB.现在它将不再开始使用 service mysql start .
I've just updated MariaDB using apt-get dist-upgrade. Now it won't start using service mysql start anymore.
不过,我可以以root用户身份运行它或执行以下操作: sudo -u mysql mysqld_safe ,MariaDB可以正常启动.文件夹/home/mysql由mysql用户和组拥有.
I can however, run it as root or do: sudo -u mysql mysqld_safe then MariaDB starts up fine. The folder /home/mysql is owned by the mysql user and group.
我发现此函数将引发错误: > https://github.com/MariaDB/server/blob/7ff44b1a832b005264994cbdfc52cd /sql/mysqld.cc#L9865
I've found the error to be thrown in this function: https://github.com/MariaDB/server/blob/7ff44b1a832b005264994cbdfc52f93f69b92cdc/sql/mysqld.cc#L9865
我不知道下一步该怎么做.有指针吗?
I can't figure out what to do next. Any pointers?
推荐答案
要从/home运行MariaDB SQL,请在文件/usr/lib/systemd/system/mariadb.service中进行更改:
To run MariaDB SQL from /home, in the file /usr/lib/systemd/system/mariadb.service, just change :
ProtectHome=true
至:
ProtectHome=false
这篇关于MariaDB更新后无法启动:[警告]无法创建测试文件/home/mysql/beta.lower-test的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!