Mysql service fail to start

This article is about the specific mysql error which is written in few lines below.

100723 16:14:08 InnoDB: Started; log sequence number 0 43655
100723 16:14:08 [ERROR] /usr/libexec/mysqld: Can’t find file: ‘./mysql/host.frm’ (errno: 13)
100723 16:14:08 [ERROR] /usr/libexec/mysqld: Can’t find file: ‘./mysql/host.frm’ (errno: 13)
100723 16:14:08 [ERROR] Fatal error: Can’t open and lock privilege tables: Can’t find file: ‘./mysql/host.frm’ (errno: 13)
100723 16:14:08 mysqld ended


Solution:-

When encounter this error it means, mysql do not have permissions on the mysql database files, which normally resides in /var/lib/mysql/mysql. if you installed it via yum on Centos system.

Just change the owner ship of the files with

chown mysql:mysql /var/lib/mysql -R

Now start service and hopefully you will successfully start the mysql service.

service mysqld start

Good Luck

One thought on “Mysql service fail to start

Leave a Reply

Your email address will not be published. Required fields are marked *