Starting mysql

Daniel J Walsh dwalsh at redhat.com
Mon Dec 12 17:09:15 UTC 2011


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 12/12/2011 01:15 AM, Tom Lane wrote:
> "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

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-----


More information about the devel mailing list