Mysql Can't find file: './mysql/host.frm' (errno: 13) 的解决方法

安装mysql后，使用mysqld_safe启动，错误如下：

[ROOT mysql]$ mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
100313 10:15:09  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
100313 10:15:09  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
100313 10:15:09  InnoDB: Started; log sequence number 0 43655
100313 10:15:09 [ERROR] mysqld: Can't create/write to file '/var/run/mysqld' (Errcode: 21)
100313 10:15:09 [ERROR] Can't start server: can't create PID file: Is a directory
[ROOT mysql]$ mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
100313 10:16:23  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
100313 10:16:23  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
100313 10:16:23  InnoDB: Started; log sequence number 0 43655
100313 10:16:23 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13)
100313 10:16:23 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13)
100313 10:16:23 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

 

呵呵，可能是我太笨了，找了很多论坛，都是说都权限问题，但没找到解决方法，最后在find -iname '*host.frm*'里知道host.frm是在mysql的系统表里，进行系统表查看权限：

[ROOT mysql]$ ll
total 780
-rwxrwx--- 1 root root   8820 2010-03-13 09:20 columns_priv.frm
-rwxrwx--- 1 root root      0 2010-03-13 09:20 columns_priv.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 columns_priv.MYI
-rwxrwx--- 1 root root   9494 2010-03-13 09:20 db.frm
-rwxrwx--- 1 root root    876 2010-03-13 09:20 db.MYD
-rwxrwx--- 1 root root   4096 2010-03-13 09:20 db.MYI
-rwxrwx--- 1 root root   8665 2010-03-13 09:20 func.frm
-rwxrwx--- 1 root root      0 2010-03-13 09:20 func.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 func.MYI
-rwxrwx--- 1 root root   8700 2010-03-13 09:20 help_category.frm
-rwxrwx--- 1 root root  20916 2010-03-13 09:20 help_category.MYD
-rwxrwx--- 1 root root   3072 2010-03-13 09:20 help_category.MYI
-rwxrwx--- 1 root root   8612 2010-03-13 09:20 help_keyword.frm
-rwxrwx--- 1 root root  78997 2010-03-13 09:20 help_keyword.MYD
-rwxrwx--- 1 root root  14336 2010-03-13 09:20 help_keyword.MYI
-rwxrwx--- 1 root root   8630 2010-03-13 09:20 help_relation.frm
-rwxrwx--- 1 root root   7425 2010-03-13 09:20 help_relation.MYD
-rwxrwx--- 1 root root  16384 2010-03-13 09:20 help_relation.MYI
-rwxrwx--- 1 root root   8770 2010-03-13 09:20 help_topic.frm
-rwxrwx--- 1 root root 347064 2010-03-13 09:20 help_topic.MYD
-rwxrwx--- 1 root root  17408 2010-03-13 09:20 help_topic.MYI
-rwxrwx--- 1 root root   9416 2010-03-13 09:20 host.frm
-rwxrwx--- 1 root root      0 2010-03-13 09:20 host.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 host.MYI
-rwxrwx--- 1 root root   9691 2010-03-13 09:20 proc.frm
-rwxrwx--- 1 root root      0 2010-03-13 09:20 proc.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 proc.MYI
-rwxrwx--- 1 root root   8875 2010-03-13 09:20 procs_priv.frm
-rwxrwx--- 1 root root      0 2010-03-13 09:20 procs_priv.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 procs_priv.MYI
-rwxrwx--- 1 root root   8947 2010-03-13 09:20 tables_priv.frm
-rwxrwx--- 1 root root      0 2010-03-13 09:20 tables_priv.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 tables_priv.MYI
-rwxrwx--- 1 root root   8636 2010-03-13 09:20 time_zone.frm
-rwxrwx--- 1 root root   8624 2010-03-13 09:20 time_zone_leap_second.frm
-rwxrwx--- 1 root root      0 2010-03-13 09:20 time_zone_leap_second.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 time_zone_leap_second.MYI
-rwxrwx--- 1 root root      0 2010-03-13 09:20 time_zone.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 time_zone.MYI
-rwxrwx--- 1 root root   8606 2010-03-13 09:20 time_zone_name.frm
-rwxrwx--- 1 root root      0 2010-03-13 09:20 time_zone_name.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 time_zone_name.MYI
-rwxrwx--- 1 root root   8686 2010-03-13 09:20 time_zone_transition.frm
-rwxrwx--- 1 root root      0 2010-03-13 09:20 time_zone_transition.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 time_zone_transition.MYI
-rwxrwx--- 1 root root   8748 2010-03-13 09:20 time_zone_transition_type.frm
-rwxrwx--- 1 root root      0 2010-03-13 09:20 time_zone_transition_type.MYD
-rwxrwx--- 1 root root   1024 2010-03-13 09:20 time_zone_transition_type.MYI
-rwxrwx--- 1 root root  10330 2010-03-13 09:20 user.frm
-rwxrwx--- 1 root root    224 2010-03-13 09:20 user.MYD
-rwxrwx--- 1 root root   2048 2010-03-13 09:20 user.MYI

 

晕，原来真是权限问题：

[ROOT mysql]$ chown mysql *

[ROOT mysql]$ chgrp mysql *

[ROOT mysql]$ chmod ug+rwx *

 

再重启mysql即可

评论

3 楼 763863446 2017-05-12  

非常感谢博主，整好解决了问题！！！ 

2 楼 java_doom 2013-09-09  

不错 太赞了 我也遇到同样的问题 看到你这篇才解决

1 楼 thebye85 2010-11-03  

原来如此，刚才遇到这个问题。谢谢