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

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]# lltotal 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]# lltotal 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]#

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。