-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 12/12/2011 01:15 AM, Tom Lane wrote:
"Paul F. Johnson" <paul(a)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
SELinux error messages could also be in /var/log/audit/audit.log
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla -
http://enigmail.mozdev.org/
iEYEARECAAYFAk7mNTsACgkQrlYvE4MpobOtmACg2roZm6sPjv/ymXn4P8FTn4Cm
/VoAoLja7rgIV4bQY5MXgsr+yIf9IuBm
=WPb8
-----END PGP SIGNATURE-----