MySql error Can’t open file: ‘host.MYI’. (errno: 142)

#service mysql start;tail -f /var/log/mysqld.log gives the following error.

=================================

080303 11:14:35 /usr/sbin/mysqld: Can’t create/write to file ‘/var/run/mysqld/mysqld.pid’ (Errcode: 2)
080303 11:14:35 /usr/sbin/mysqld: Can’t open file: ‘host.MYI’. (errno: 142)
080303 11:14:35 Fatal error: Can’t open privilege tables: File ‘/usr/share/mysql/charsets/?.conf’ not found (Errcode: 2)
080303 11:14:35 Aborting
===============

 

Fix:

# vi /usr/share/mysql/charsets/Index

// 설치되어있는 mysql 디렉토리 안에서 Index 파일을 찾습니다.

// 보통은 /usr/local/mysql/share/mysql/charsets/Index 입니다.

 

Add the following line at the end.

cp1251 83 

// 기존의 cp1251 의 번호를 83으로 변경합니다.

 

[출처] http://myfindings.wordpress.com/2008/03/03/mysql-error-cant-open-file-hostmyi-errno-142/