Hello,
Thank you! This is what I needed to do to get the server started. I executed mysql_install_db as the operating system's root user which may have been a mistake? That set the permissions on the 'mysql' database in the data directory to root.root, causing the server to fail to start when it couldn't open or read host.frm. Changing the permissions to mysql.mysql for the directory and all files in it fixed the problem and allowed me to start the server.
Bob Cochran Greenbelt, Maryland, USA
Gleb Paharenko wrote:
Hello.
Probably mysql_install_db wasn't executed due to SElinux restrictions. Execute it is manually. Check that your data directory has the 'mysql' database.
Robert L Cochran <[EMAIL PROTECTED]> wrote:
When I installed MySQL-server version 5.0.4 on my Fedora Core 3 system (Linux x86, using RPMs from MySQL.com) with SELinux running in enforcing mode, the server failed to start, possibly due to denials from the SELinux implementation.
'restorecon -R -v /var/lib/mysql' failed to let the server start. 'restorecon -R -v /usr/lib/mysql' failed to let the server start. 'restorecon -v /usr/sbin/mysqld' failed to let the server start.
I then disabled SELinux just for the mysqld application. However MySQL 5's server won't start.
I located the error log and it has this message:
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
How can I fix this problem? Should I uninstall MySQL (with 'rpm -e') and reinstall it? This should work if I disabled SELinux for mysqld?
Thanks for your help
Bob Cochran Greenbelt, Maryland, USA
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
