Starting mysql

Tom Lane tgl at redhat.com
Mon Dec 12 06:15:58 UTC 2011


"Paul F. Johnson" <paul at all-the-johnsons.co.uk> writes:
> /var/log/mysqld.log shows this

> 111211 20:48:32 [ERROR] /usr/libexec/mysqld: Can't find file:
> './mysql/proxies_priv.frm' (errno: 13)
> 111211 20:48:32 [ERROR] Fatal error: Can't open and lock privilege
> tables: Can't find file: './mysql/proxies_priv.frm' (errno: 13)

I think the nearby suggestions to run mysql_upgrade are probably right,
especially if you're trying to upgrade from some pre-5.5 version of
mysql.  But it occurs to me that there's some chance of SELinux
interference; do you see any avc messages in /var/log/messages?
If so, restorecon on the /var/lib/mysql tree ought to fix that.

Alternatively, if you don't have any valuable data in your database
(and I hope you aren't running anything *real* critical on rawhide ;-))
you could just rm -rf everything under /var/lib/mysql and let it
initialize a brand new database.

			regards, tom lane


More information about the devel mailing list