mysqld:无法创建/写入文件(错误代码: 13)
mysqld:无法创建/写入文件(错误代码: 13)
提问于 2014-05-02 17:12:08
我最近在我的archlinux机器上安装了mariadb，并且想用不同的data和tmp目录运行mysqld
[mysqld]
user = mysql
port = 3306
datadir = <datapath>
tmpdir = <datapath>/tmp运行mysqld时，我收到以下错误消息：
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.8
InnoDB: Using Linux native AIO
[ERROR] mysqld: Can't create/write to file '<datapath>/tmp/ib8dOkCX' (Errcode: 13)
InnoDB: Error: unable to create temporary file; errno: 13
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] mysqld: Can't create/write to file '<datapath>/aria_log_control' (Errcode: 13)
[ERROR] mysqld: Got error 'Can't create file' when trying to use aria control file '<datapath>/aria_log_control'
[ERROR] Plugin 'Aria' init function returned error.
[ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting
[Note] mysqld: Shutdown complete我已经确保mysql用户是所有者，并且对data和tmp目录具有适当的权限。
当以root身份运行mysqld时，一切工作正常。在使用默认的tmpdir时，我仍然会在创建/写入文件/aria_log_control时出现错误。有谁知道我哪里失败了吗？
回答 1
Stack Overflow用户
发布于 2018-06-09 03:43:31
您应该将<datapath>替换为包含临时文件夹的数据文件的实际路径
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/23424605
复制相关文章
相似问题