Saturday, November 8, 2014

mysql failed to start up right after install

in /var/log/mysqld.log you see this line toward the end:

“Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist”


Do yourself a favor and just uninstall mysql, disable selinux, reboot, then reinstall mysql:


1. yum remove mysql-server

rm -rf /var/lib/mysql

2. nano /etc/selinux/config

– “enforcing” -> “disabled”

3. reboot

4. yum install mysql-server

5. continue where you left off

– your my.cnf file will remain


I’m sure someone really really disagrees with the “disable selinux” bit ;)





No comments:

Post a Comment