Thursday, December 19, 2013

mysql error ./mysql/host.frm

Problem:
131219 22:51:39 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
131219 22:51:39 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
131219 22:51:39 mysqld_safe mysqld from pid file /usr/local/mysql/myhostname.local.pid ended

Solution:
root@myhostname [/usr/local/mysql] # chown -R mysql:mysql /usr/local/mysql
root@myhostname [/usr/local/mysql] # find /usr/local/mysql -type d -exec chmod 700 {} \;
root@myhostname [/usr/local/mysql] # find /usr/local/mysql -type f -exec chmod 660 {} \;

No comments: