Can't find file: './performance_schema/cond_instances.frm' (errno: 13 - Permission denied)

错误日志

2015-05-16 12:22:03 3325 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

2015-05-16 12:22:03 3325 [Note] Server socket created on IP: '0.0.0.0'.
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/cond_instances.frm' (errno: 13 - Permission denied)
2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_current.frm' (errno: 13 - Permission denied)
2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_history.frm' (errno: 13 - Permission denied)
2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_history_long.frm' (errno: 13 - Permission denied)
2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_summary_by_host_by_event_name.frm' (errno: 13 - Permission denied)
2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_summary_by_instance.frm' (errno: 13 - Permission denied)
2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_summary_by_thread_by_event_name.frm' (errno: 13 - Permission denied)
2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_summary_by_user_by_event_name.frm' (errno: 13 - Permission denied)
2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_summary_by_account_by_event_name.frm' (errno: 13 - Permission denied)
2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/events_waits_summary_global_by_event_name.frm' (errno: 13 - Permission denied)
2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
2015-05-16 12:22:03 3325 [ERROR] /usr/sbin/mysqld: Can't find file: './performance_schema/file_instances.frm' (errno: 13 - Permission denied)

2015-05-16 12:22:03 3325 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure

根据以上内容，又查了百度，说是权限问题；

我的MySQL安装目录在/var/lib/mysql下；进入performance_schema目录执行如下命令：

[root@localhost performance_schema]# chown mysql *
[root@localhost performance_schema]# chgrp mysql *
[root@localhost performance_schema]# chmod ug+rwx *

[root@localhost mysql]# cd performance_schema/
[root@localhost performance_schema]# ll
total 632
-rw-rw---- 1 root root  8706 Mar  1 22:05 accounts.frm
-rw-rw---- 1 root root  8624 Mar  1 22:05 cond_instances.frm
-rw-rw---- 1 root root    61 Mar  1 22:05 db.opt
-rw-rw---- 1 root root  8991 Mar  1 22:05 events_stages_current.frm
-rw-rw---- 1 root root  8991 Mar  1 22:05 events_stages_history.frm
-rw-rw---- 1 root root  8991 Mar  1 22:05 events_stages_history_long.frm
-rw-rw---- 1 root root  8874 Mar  1 22:05 events_stages_summary_by_account_by_event_name.frm
-rw-rw---- 1 root root  8844 Mar  1 22:05 events_stages_summary_by_host_by_event_name.frm
-rw-rw---- 1 root root  8854 Mar  1 22:05 events_stages_summary_by_thread_by_event_name.frm
-rw-rw---- 1 root root  8844 Mar  1 22:05 events_stages_summary_by_user_by_event_name.frm
-rw-rw---- 1 root root  8814 Mar  1 22:05 events_stages_summary_global_by_event_name.frm
-rw-rw---- 1 root root 10525 Mar  1 22:05 events_statements_current.frm
-rw-rw---- 1 root root 10525 Mar  1 22:05 events_statements_history.frm
-rw-rw---- 1 root root 10525 Mar  1 22:05 events_statements_history_long.frm
-rw-rw---- 1 root root 10000 Mar  1 22:05 events_statements_summary_by_account_by_event_name.frm
-rw-rw---- 1 root root 10102 Mar  1 22:05 events_statements_summary_by_digest.frm
-rw-rw---- 1 root root  9970 Mar  1 22:05 events_statements_summary_by_host_by_event_name.frm
-rw-rw---- 1 root root  9980 Mar  1 22:05 events_statements_summary_by_thread_by_event_name.frm
-rw-rw---- 1 root root  9970 Mar  1 22:05 events_statements_summary_by_user_by_event_name.frm
-rw-rw---- 1 root root  9940 Mar  1 22:05 events_statements_summary_global_by_event_name.frm
-rw-rw---- 1 root root  9389 Mar  1 22:05 events_waits_current.frm
-rw-rw---- 1 root root  9389 Mar  1 22:05 events_waits_history.frm
-rw-rw---- 1 root root  9389 Mar  1 22:05 events_waits_history_long.frm
-rw-rw---- 1 root root  8874 Mar  1 22:05 events_waits_summary_by_account_by_event_name.frm
-rw-rw---- 1 root root  8844 Mar  1 22:05 events_waits_summary_by_host_by_event_name.frm
-rw-rw---- 1 root root  8878 Mar  1 22:05 events_waits_summary_by_instance.frm
-rw-rw---- 1 root root  8854 Mar  1 22:05 events_waits_summary_by_thread_by_event_name.frm
-rw-rw---- 1 root root  8844 Mar  1 22:05 events_waits_summary_by_user_by_event_name.frm
-rw-rw---- 1 root root  8814 Mar  1 22:05 events_waits_summary_global_by_event_name.frm
-rw-rw---- 1 root root  8654 Mar  1 22:05 file_instances.frm
-rw-rw---- 1 root root  9740 Mar  1 22:05 file_summary_by_event_name.frm
-rw-rw---- 1 root root  9844 Mar  1 22:05 file_summary_by_instance.frm
-rw-rw---- 1 root root 10483 Mar  1 22:05 host_cache.frm
-rw-rw---- 1 root root  8676 Mar  1 22:05 hosts.frm
-rw-rw---- 1 root root  8684 Mar  1 22:05 mutex_instances.frm
-rw-rw---- 1 root root  8908 Mar  1 22:05 objects_summary_global_by_type.frm
-rw-rw---- 1 root root  8776 Mar  1 22:05 performance_timers.frm
-rw-rw---- 1 root root  8758 Mar  1 22:05 rwlock_instances.frm
-rw-rw---- 1 root root  8716 Mar  1 22:05 session_account_connect_attrs.frm
-rw-rw---- 1 root root  8716 Mar  1 22:05 session_connect_attrs.frm
-rw-rw---- 1 root root  8620 Mar  1 22:05 setup_actors.frm
-rw-rw---- 1 root root  8605 Mar  1 22:05 setup_consumers.frm
-rw-rw---- 1 root root  8637 Mar  1 22:05 setup_instruments.frm
-rw-rw---- 1 root root  8751 Mar  1 22:05 setup_objects.frm
-rw-rw---- 1 root root  8650 Mar  1 22:05 setup_timers.frm
-rw-rw---- 1 root root  8818 Mar  1 22:05 socket_instances.frm
-rw-rw---- 1 root root  9740 Mar  1 22:05 socket_summary_by_event_name.frm
-rw-rw---- 1 root root  9804 Mar  1 22:05 socket_summary_by_instance.frm
-rw-rw---- 1 root root 10578 Mar  1 22:05 table_io_waits_summary_by_index_usage.frm
-rw-rw---- 1 root root 10488 Mar  1 22:05 table_io_waits_summary_by_table.frm
-rw-rw---- 1 root root 13518 Mar  1 22:05 table_lock_waits_summary_by_table.frm
-rw-rw---- 1 root root  9201 Mar  1 22:05 threads.frm
-rw-rw---- 1 root root  8676 Mar  1 22:05 users.frm
[root@localhost performance_schema]# chown mysql *
[root@localhost performance_schema]# chgrp mysql *
[root@localhost performance_schema]# chmod ug+rwx *
[root@localhost performance_schema]# ll
total 632
-rwxrwx--- 1 mysql mysql  8706 Mar  1 22:05 accounts.frm
-rwxrwx--- 1 mysql mysql  8624 Mar  1 22:05 cond_instances.frm
-rwxrwx--- 1 mysql mysql    61 Mar  1 22:05 db.opt
-rwxrwx--- 1 mysql mysql  8991 Mar  1 22:05 events_stages_current.frm
-rwxrwx--- 1 mysql mysql  8991 Mar  1 22:05 events_stages_history.frm
-rwxrwx--- 1 mysql mysql  8991 Mar  1 22:05 events_stages_history_long.frm
-rwxrwx--- 1 mysql mysql  8874 Mar  1 22:05 events_stages_summary_by_account_by_event_name.frm
-rwxrwx--- 1 mysql mysql  8844 Mar  1 22:05 events_stages_summary_by_host_by_event_name.frm
-rwxrwx--- 1 mysql mysql  8854 Mar  1 22:05 events_stages_summary_by_thread_by_event_name.frm
-rwxrwx--- 1 mysql mysql  8844 Mar  1 22:05 events_stages_summary_by_user_by_event_name.frm
-rwxrwx--- 1 mysql mysql  8814 Mar  1 22:05 events_stages_summary_global_by_event_name.frm
-rwxrwx--- 1 mysql mysql 10525 Mar  1 22:05 events_statements_current.frm
-rwxrwx--- 1 mysql mysql 10525 Mar  1 22:05 events_statements_history.frm
-rwxrwx--- 1 mysql mysql 10525 Mar  1 22:05 events_statements_history_long.frm
-rwxrwx--- 1 mysql mysql 10000 Mar  1 22:05 events_statements_summary_by_account_by_event_name.frm
-rwxrwx--- 1 mysql mysql 10102 Mar  1 22:05 events_statements_summary_by_digest.frm
-rwxrwx--- 1 mysql mysql  9970 Mar  1 22:05 events_statements_summary_by_host_by_event_name.frm
-rwxrwx--- 1 mysql mysql  9980 Mar  1 22:05 events_statements_summary_by_thread_by_event_name.frm
-rwxrwx--- 1 mysql mysql  9970 Mar  1 22:05 events_statements_summary_by_user_by_event_name.frm
-rwxrwx--- 1 mysql mysql  9940 Mar  1 22:05 events_statements_summary_global_by_event_name.frm
-rwxrwx--- 1 mysql mysql  9389 Mar  1 22:05 events_waits_current.frm
-rwxrwx--- 1 mysql mysql  9389 Mar  1 22:05 events_waits_history.frm
-rwxrwx--- 1 mysql mysql  9389 Mar  1 22:05 events_waits_history_long.frm
-rwxrwx--- 1 mysql mysql  8874 Mar  1 22:05 events_waits_summary_by_account_by_event_name.frm
-rwxrwx--- 1 mysql mysql  8844 Mar  1 22:05 events_waits_summary_by_host_by_event_name.frm
-rwxrwx--- 1 mysql mysql  8878 Mar  1 22:05 events_waits_summary_by_instance.frm
-rwxrwx--- 1 mysql mysql  8854 Mar  1 22:05 events_waits_summary_by_thread_by_event_name.frm
-rwxrwx--- 1 mysql mysql  8844 Mar  1 22:05 events_waits_summary_by_user_by_event_name.frm
-rwxrwx--- 1 mysql mysql  8814 Mar  1 22:05 events_waits_summary_global_by_event_name.frm
-rwxrwx--- 1 mysql mysql  8654 Mar  1 22:05 file_instances.frm
-rwxrwx--- 1 mysql mysql  9740 Mar  1 22:05 file_summary_by_event_name.frm
-rwxrwx--- 1 mysql mysql  9844 Mar  1 22:05 file_summary_by_instance.frm
-rwxrwx--- 1 mysql mysql 10483 Mar  1 22:05 host_cache.frm
-rwxrwx--- 1 mysql mysql  8676 Mar  1 22:05 hosts.frm
-rwxrwx--- 1 mysql mysql  8684 Mar  1 22:05 mutex_instances.frm
-rwxrwx--- 1 mysql mysql  8908 Mar  1 22:05 objects_summary_global_by_type.frm
-rwxrwx--- 1 mysql mysql  8776 Mar  1 22:05 performance_timers.frm
-rwxrwx--- 1 mysql mysql  8758 Mar  1 22:05 rwlock_instances.frm
-rwxrwx--- 1 mysql mysql  8716 Mar  1 22:05 session_account_connect_attrs.frm
-rwxrwx--- 1 mysql mysql  8716 Mar  1 22:05 session_connect_attrs.frm
-rwxrwx--- 1 mysql mysql  8620 Mar  1 22:05 setup_actors.frm
-rwxrwx--- 1 mysql mysql  8605 Mar  1 22:05 setup_consumers.frm
-rwxrwx--- 1 mysql mysql  8637 Mar  1 22:05 setup_instruments.frm
-rwxrwx--- 1 mysql mysql  8751 Mar  1 22:05 setup_objects.frm
-rwxrwx--- 1 mysql mysql  8650 Mar  1 22:05 setup_timers.frm
-rwxrwx--- 1 mysql mysql  8818 Mar  1 22:05 socket_instances.frm
-rwxrwx--- 1 mysql mysql  9740 Mar  1 22:05 socket_summary_by_event_name.frm
-rwxrwx--- 1 mysql mysql  9804 Mar  1 22:05 socket_summary_by_instance.frm
-rwxrwx--- 1 mysql mysql 10578 Mar  1 22:05 table_io_waits_summary_by_index_usage.frm
-rwxrwx--- 1 mysql mysql 10488 Mar  1 22:05 table_io_waits_summary_by_table.frm
-rwxrwx--- 1 mysql mysql 13518 Mar  1 22:05 table_lock_waits_summary_by_table.frm
-rwxrwx--- 1 mysql mysql  9201 Mar  1 22:05 threads.frm
-rwxrwx--- 1 mysql mysql  8676 Mar  1 22:05 users.frm
[root@localhost performance_schema]#