mysql权限问题,求解答

9ding

环境：centos 5.5 x86_64
应用:bind+dlz
rpm安装mysql数据库,数据库从上线一直在用没出过问题,今天新加了个库dns查询不到库里面的记录
mysql数据目录拥有者是mysql,索性修改/etc/my.cnf后设置user=root,然后重启mysql,dns解析就正常了

问题是现在改回来user=mysql后,重新启动库就起不来了,还请数据库大牛多多指教。
查看错误日志如下：

111028 12:49:36  mysqld started
111028 12:49:36  InnoDB: Started; log sequence number 0 43665
/usr/libexec/mysqld: File './mysql-bin.000034' not found (Errcode: 13)
111028 12:49:36 [ERROR] Failed to open log (file './mysql-bin.000034', errno 13)
111028 12:49:36 [ERROR] Could not open log file
111028 12:49:36 [ERROR] Can't init tc log
111028 12:49:36 [ERROR] Aborting

111028 12:49:36  InnoDB: Starting shutdown...
111028 12:49:37  InnoDB: Shutdown completed; log sequence number 0 43665
111028 12:49:37 [Note] /usr/libexec/mysqld: Shutdown complete

111028 12:49:37  mysqld ended

111028 12:50:32  mysqld started
111028 12:50:32 [Warning] Ignoring user change to 'mysql' because the user was set to 'root' earlier on the command line

111028 12:50:32  InnoDB: Started; log sequence number 0 43665
111028 12:50:32 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

飞鸿无痕

回复 1# 9ding

看看/var/lib/mysql文件夹的权限

cenalulu

file './mysql-bin.000034', errno 13。

error 13：没有权限。
看看这个文件是不是 mysql 所属的文件

9ding

我的是/data/mysql是数据库数据的路径
drwxr-xr-x 7 mysql mysql 4096 Oct 28 12:50 /data/mysql/

mysql-bin.000034  这个文件用户是mysql组是root权限是660

请各位帮忙解决下。

atyu30

/usr/libexec/mysqld: File './mysql-bin.000034' not found (Errcode: 13)
这个文件呢

9ding

ll -ld  /usr/libexec/mysqld   
-rwxr-xr-x 1 root root 7721832 May 10 06:18 /usr/libexec/mysqld

CKFuture

学习