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

Source: Internet
Author: User
Tags chmod localhost mysql

Error log


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


According to the above content, and check the Baidu, said is the authority problem;

My MySQL installation directory is under/var/lib/mysql; Enter the Performance_schema directory to execute the following command:

[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 8 706 Mar 1 22:05 accounts.frm-rw-rw----1 root 8624 Mar 1 22:05 cond_instances.frm-rw-rw----1 root root Ma R 1 22:05 db.opt-rw-rw----1 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 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 8844 Mar 1 22:05 even TS_STAGES_SUMMARY_BY_HOST_BY_EVENT_NAME.FRM-RW-RW----1 root 8854 Mar 1 22:05 events_stages_summary_by_thread_by_  EVENT_NAME.FRM-RW-RW----1 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 10525 Mar 1 22:05 events_s Tatements_current.frm-rw-RW----1 root 10525 Mar 1 22:05 events_statements_history.frm-rw-rw----1 root 10525 Mar 1 22:05 events_stat
EMENTS_HISTORY_LONG.FRM-RW-RW----1 root 10000 Mar 1 22:05 events_statements_summary_by_account_by_event_name.frm -RW-RW----1 root 10102 Mar 1 22:05 events_statements_summary_by_digest.frm-rw-rw----1 root 9970 Mar 1 22:0 5 EVENTS_STATEMENTS_SUMMARY_BY_HOST_BY_EVENT_NAME.FRM-RW-RW----1 root 9980 Mar 1 22:05 events_statements_summary_ 
BY_THREAD_BY_EVENT_NAME.FRM-RW-RW----1 root 9970 Mar 1 22:05 events_statements_summary_by_user_by_event_name.frm  -RW-RW----1 root 9940 Mar 1 22:05 events_statements_summary_global_by_event_name.frm-rw-rw----1 root 9389 Mar 1 22:05 events_waits_current.frm-rw-rw----1 root 9389 Mar 1 22:05 events_waits_history.frm-rw-rw----1 roo T-root 9389 Mar 1 22:05 events_waits_history_long.frm-rw-rw----1 root 8874 Mar 1 22:05 events_waits_summary_by_
Account_by_event_name.frm-RW-RW----1 root 8844 Mar 1 22:05 events_waits_summary_by_host_by_event_name.frm-rw-rw----1 root 8878 Mar 1 22:05 events_waits_summary_by_instance.frm-rw-rw----1 root 8854 Mar 1 22:05 events_waits_summary_by_thread_by_ EVENT_NAME.FRM-RW-RW----1 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 8654 Mar 1 22:05 file_insta NCES.FRM-RW-RW----1 root 9740 Mar 1 22:05 file_summary_by_event_name.frm-rw-rw----1 root 9844 Mar 1 22:0  5 FILE_SUMMARY_BY_INSTANCE.FRM-RW-RW----1 root root 10483 Mar 1 22:05 host_cache.frm-rw-rw----1 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 8908 Mar 1 22:05   OBJECTS_SUMMARY_GLOBAL_BY_TYPE.FRM-RW-RW----1 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 8716 Mar 1 22:05 session_account_connect_attrs.frm-rw-rw----1 root 8716  Mar 1 22:05 session_connect_attrs.frm-rw-rw----1 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 8637 Mar 1 22:05 setup_instruments.frm-rw-rw----1 root ro  OT 8751 Mar 1 22:05 setup_objects.frm-rw-rw----1 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 9740 Mar 1 22:05 socket_summary_by_event_name.frm-rw-rw- ---1 root 9804 mar 1 22:05 socket_summary_by_instance.frm-rw-rw----1 root 10578 Mar 1 22:05 table_io_waits _SUMMARY_BY_INDEX_USAGE.FRM-RW-RW----1 root 10488 Mar 1 22:05 table_io_waits_summary_by_table.frm-rw-rw----1 roo T-root 13518 Mar 1 22:05 table_lock_waits_summary_by_table.frm-rw-rw----1 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 mysq L * [root@localhost performance_schema]# chmod ug+rwx * [root@localhost performance_schema]# ll Total 632-rwxrwx---1 mys  QL MySQL 8706 Mar 1 22:05 accounts.frm-rwxrwx---1 mysql mysql 8624 Mar 1 22:05 cond_instances.frm-rwxrwx---1 mysql MySQL 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 mysq L 8844 Mar 1 22:05 events_stages_summary_by_host_by_event_name.frm-rwxrwx---1 mysql mysql 8854 Mar 1 22:05 events_st AGES_SUMMARY_BY_THREAD_BY_EVENT_NAME.FRM-RWXRWX---1 mysql mysql 8844 Mar 1 22:05 events_stages_summary_by_user_by_eve NT_NAME.FRM-RWXRWX---1mysql 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 my SQL MySQL 9980 Mar 1 22:05 events_statements_summary_by_thread_by_event_name.frm-rwxrwx---1 mysql mysql 9970 Mar 1 2 2:05 events_statements_summary_by_user_by_event_name.frm-rwxrwx---1 mysql mysql 9940 Mar 1 22:05 events_statements_sum MARY_GLOBAL_BY_EVENT_NAME.FRM-RWXRWX---1 mysql mysql 9389 Mar 1 22:05 events_waits_current.frm-rwxrwx---1 mysql mysq L 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 my SQL 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 mysq  l 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 m Ysql 8716 Mar 1 22:05 session_account_connect_attrs.frm-rwxrwx---1 mysql mysql 8716 Mar 1 22:05 session_connect_attr S.FRM-RWXRWX---1 mysql mysql 8620 Mar 1 22:05 setup_actors.frm-rwxrwx---1 mysql mysql 8605 Mar 1 22:05 setup_consu MERS.FRM-RWXRWX---1 mysql mysql 8637 Mar 1 22:05 setup_instruments.frm-rwxrwx---1 mysql mysql 8751 Mar 1 22:05 Set UP_OBJECTS.FRM-RWXRWX---1 mysql mysql 8650 Mar 1 22:05 setup_timers.frm-rwxrwx---1 mysql mysql 8818 Mar 1 22:05 so  CKET_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_ind EX_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_loc  K_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]#















Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.