Date: Tue, 19 May 2009 09:35:47 +0100 From: Tom Evans <tevans.uk@googlemail.com> To: Sam Wun <swun2010@gmail.com> Cc: freebsd-database@freebsd.org Subject: Re: '/var/db/mysql/mysql-bin.index' not found Message-ID: <1242722147.30192.8.camel@strangepork.london.mintel.ad> In-Reply-To: <736c47cb0905170613w7768c7a8l651e6d5be280554f@mail.gmail.com>
index | next in thread | previous in thread | raw e-mail
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 Tomhome | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1242722147.30192.8.camel>