'/var/db/mysql/mysql-bin.index' not found

[Tom Evans]

On Sun, 2009-05-17 at 23:13 +1000, Sam Wun wrote:
> Hi,
> 
> I am running mysql 5.1 server in freebsd 7.2.
> 
> I got the an error when I tried to start the following command:
> # /usr/local/bin/mysqld_safe --skip-grant-tables
> 
> Error is:
> 090517 23:05:19 mysqld_safe Starting mysqld daemon with databases from
> /var/db/mysql
> /usr/local/libexec/mysqld: File '/var/db/mysql/mysql-bin.index' not
> found (Errcode: 13)
> 090517 23:05:19 [ERROR] Aborting
> 
> 090517 23:05:19 [Note] /usr/local/libexec/mysqld: Shutdown complete
> 
> Here are all files in the directory:
> 
> wp1:mysql # pwd
> /var/db/mysql
> wp1:mysql # ls -l
> total 22002
> drwx------  4 root   mysql       512 May 17 23:05 ./
> drwxr-xr-x  9 root   wheel       512 May 12 13:57 ../
> -rw-rw----  1 mysql  mysql   5242880 May 17 22:29 ib_logfile0
> -rw-rw----  1 mysql  mysql   5242880 May 17 22:12 ib_logfile1
> -rw-rw----  1 mysql  mysql  10485760 May 17 22:29 ibdata1
> drwx------  2 root   mysql      2048 May 12 13:57 mysql/
> -rw-rw----  1 mysql  mysql       125 May 17 22:16 mysql-bin.000001
> -rw-rw----  1 mysql  mysql       125 May 17 22:17 mysql-bin.000002
> -rw-rw----  1 mysql  mysql       951 May 17 22:19 mysql-bin.000003
> -rw-rw----  1 mysql  mysql    708461 May 17 22:19 mysql-bin.000004
> -rw-rw----  1 mysql  mysql       406 May 17 22:29 mysql-bin.000005
> -rw-rw----  1 root   mysql       951 May 17 22:27 mysql-bin.000006
> -rw-rw----  1 root   mysql    708461 May 17 22:27 mysql-bin.000007
> -rw-rw----  1 mysql  mysql       133 May 17 22:27 mysql-bin.index
> drwx------  2 root   mysql       512 May 12 13:57 test/
> -rw-rw----  1 mysql  mysql      6841 May 17 23:05 wp1.ip6.com.au.err
> -rw-rw----  1 mysql  mysql      5681 May 17 22:17 wp1.ip6.com.au.err-old
> wp1:mysql #
> 
> The mysql-bin.index is in the path , why mysqld_safe can't pick it up?
> 
> Your help is very much appreciated.
> 
> Thanks

mysql runs as user mysql, and you have some files it cannot access -
probably the most important is the folder isn't owned by mysql, and it
also wouldn't be able to open the 'mysql' database, which stores user
info.

Cheers

Tom