尝试更改bin日志目录:找不到mysql-bin.index(错误代码:13) [英] try to change bin log directory: mysql-bin.index not found (Errcode: 13)

问题描述

MySQL 5.1.54 Ubuntu 11.04

我尝试将my.conf中的bin日志目录更改为:

[mysqld]
log_bin=/home/developer/logs/mysql/mysql-bin.log

更改后，MySQL服务器无法启动并显示错误:

/usr/sbin/mysqld: File '/home/developer/logs/mysql/mysql-bin.index' 
not found (Errcode: 13)
111005 12:47:58 [ERROR] Aborting

目录/home/developer/logs/mysql/的权限为0777

这是怎么回事?

解决方案

和往常一样，解决方案很简单但并不明显:它需要编辑apparmor设置 我刚刚在/etc/apparmor.d/usr.sbin.mysqld 中添加了一个新字符串，其中包含指向目标目录的路径:/home/developer/logs/* rw

有效！

MySQL 5.1.54 Ubuntu 11.04

I'am try to change bin log directory in my.conf as:

[mysqld]
log_bin=/home/developer/logs/mysql/mysql-bin.log

After this changes MySQL server can't start with error:

/usr/sbin/mysqld: File '/home/developer/logs/mysql/mysql-bin.index' 
not found (Errcode: 13)
111005 12:47:58 [ERROR] Aborting

Permission for directory /home/developer/logs/mysql/ is 0777

What's going on?

解决方案

As usual, the solution was simple but not obvious: it needed to edit apparmor settings I just added to /etc/apparmor.d/usr.sbin.mysqld a new string with path to target directory: /home/developer/logs/* rw

It works!

这篇关于尝试更改bin日志目录:找不到mysql-bin.index(错误代码:13)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！