帮助中心 >  技术知识库 >  数据库 >  数据库管理 >  MYSQL错误日志Can\'t find file: \'./performance_schema/cond_instances.frm\' (errno: 13 - Permission denied)

MYSQL错误日志Can\'t find file: \'./performance_schema/cond_instances.frm\' (errno: 13 - Permission denied)

2016-11-23 16:24:35 2626

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 structure2015-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 structure2015-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 structure2015-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 structure2015-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 structure2015-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 structure2015-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 structure2015-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 structure2015-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 structure2015-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 structure2015-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 *


提交成功!非常感谢您的反馈,我们会继续努力做到更好!

这条文档是否有帮助解决问题?

非常抱歉未能帮助到您。为了给您提供更好的服务,我们很需要您进一步的反馈信息:

在文档使用中是否遇到以下问题: