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