mysql權(quán)限問(wèn)題,求解答

9ding

環(huán)境：centos 5.5 x86_64
應(yīng)用:bind+dlz
rpm安裝mysql數(shù)據(jù)庫(kù),數(shù)據(jù)庫(kù)從上線一直在用沒(méi)出過(guò)問(wèn)題,今天新加了個(gè)庫(kù)dns查詢不到庫(kù)里面的記錄
mysql數(shù)據(jù)目錄擁有者是mysql,索性修改/etc/my.cnf后設(shè)置user=root,然后重啟mysql,dns解析就正常了

問(wèn)題是現(xiàn)在改回來(lái)user=mysql后,重新啟動(dòng)庫(kù)就起不來(lái)了,還請(qǐng)數(shù)據(jù)庫(kù)大牛多多指教。
查看錯(cuò)誤日志如下：

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

飛鴻無(wú)痕

回復(fù) 1# 9ding

看看/var/lib/mysql文件夾的權(quán)限

cenalulu

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

error 13：沒(méi)有權(quán)限。
看看這個(gè)文件是不是 mysql 所屬的文件

9ding

我的是/data/mysql是數(shù)據(jù)庫(kù)數(shù)據(jù)的路徑
drwxr-xr-x 7 mysql mysql 4096 Oct 28 12:50 /data/mysql/

mysql-bin.000034  這個(gè)文件用戶是mysql組是root權(quán)限是660

請(qǐng)各位幫忙解決下。

atyu30

/usr/libexec/mysqld: File './mysql-bin.000034' not found (Errcode: 13)
這個(gè)文件呢

9ding

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

CKFuture

學(xué)習(xí)