这是我的mariadb日志的输出:
$ sudo tail -f /opt/local/var/db/mariadb/rs012esb.mckenna.edu.err 130626 9:10:56 [ERROR]原生表'performance_schema' . 'mutex_instances'结构错误130626 9:10 :56 [错误] mysqld:找不到文件:' . / performance_schema / rwlock_instances.frm'(错误号码:13)130626 9:10:56 [错误]原生表'performance_schema' . 'rwlock_instances'结构错误130626 9:10:56 [错误] mysqld:找不到文件:' . / performance_schema / second_instances.frm'(错误号码:13)130626 9:10:56 [错误]原生表'performance_schema' . 'cond_instances'有错误的结构130626 9:10:56 [错误] mysqld:找不到文件:' . / performance_schema / file_instances.frm'(错误号:13)130626 9:10:56 [错误]本机表'performance_schema' . 'file_instances '具有错误的结构130626 9:10:56 [注意]事件调度程序:已加载0事件130626 9:10:56 [注意] / opt / local / lib / mariadb / bin / mysqld:准备连接 . 版本:'5.5.31-MariaDB'套接字:'/ opt / local / var / run / mariadb / mysqld.sock'端口:0源分发130626 9:14:04 [注意] / opt / local / lib / mariadb / bin / mysqld:正常关机130626 9:14:04 [注意]事件调度程序:清除队列 . 0事件130626 9:14:04 InnoDB:开始关机... 130626 9:14:04 InnoDB:关机完成;日志序列号10740580 130626 9:14:04 [注意] / opt / local / lib / mariadb / bin / mysqld:关闭完成130626 09:14:04来自pid文件的mysqld_safe mysqld / opt / local / var / db / mariadb / rs012esb.mckenna.edu.pid结束130626 09:14:25 mysqld_safe从/ opt / local / var / db / mariadb启动mysqld守护进程130626 9:14:25 [警告]设置lower_case_table_names = 2,因为/ opt的文件系统/ local / var / db / mariadb /不区分大小写130626 9:14:25 InnoDB:禁用InnoDB内存堆130626 9:14:25 InnoDB:Mutexes和rw_locks使用GCC atomic builtins 130626 9:14:25 InnoDB:压缩表使用zlib 1.2.8 130626 9:14:25 InnoDB:初始化缓冲池,大小= 128.0M 130626 9:14:25 InnoDB:缓冲池初始化130626 9:14:25 InnoDB:支持的最高文件格式是Barracuda . 130626 9:14:25 InnoDB:等待后台线程开始130626 9:14:26 Percona XtraDB(http://www.percona.com)5.5.31-MariaDB-30.2开始;日志序列号10740580 130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / events_waits_current.frm'(错误号:13)130626 9:14:26 [错误]本机表'performance_schema' . 'events_waits_current'的结构错误130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / events_waits_history.frm'(错误号码:13)130626 9:14:26 [错误]原生表' performance_schema' . 'events_waits_history'结构错误130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / events_waits_history_long.frm'(错误号码:13)130626 9:14:26 [错误]原生表'performance_schema' . 'events_waits_history_long'结构错误130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / setup_consumers.frm'(错误号:13)130626 9:14:26 [错误]原生表'performance_schema' . 'setup_consumers'结构错误130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / setup_instruments.frm'(错误号:13)130626 9: 14:26 [ER ROR]本地表'performance_schema' . 'setup_instruments'结构错误130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / setup_timers.frm'(错误号:13)130626 9:14 :26 [ERROR]原生表'performance_schema' . 'setup_timers'结构错误130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / performance_timers.frm'(错误号:13)130626 9:14:26 [ERROR]原生表'performance_schema' . 'performance_timers'结构错误130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / threads.frm'(错误号码: 13)130626 9:14:26 [错误]本地表'performance_schema' . 'threads'结构错误130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / events_waits_summary_by_thread_by_event_name.frm' (错误号:13)130626 9:14:26 [错误]本机表'performance_schema' . 'events_waits_summary_by_thread_by_event_name'结构错误130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_sche ma / events_waits_summary_by_instance.frm'(错误号码:13)130626 9:14:26 [错误]原生表'performance_schema' . 'events_waits_summary_by_instance'结构错误130626 9:14:26 [错误] mysqld:找不到文件: './performance_schema/events_waits_summary_global_by_event_name.frm'(错误号码:13)130626 9:14:26 [错误]原生表'performance_schema' . 'events_waits_summary_global_by_event_name'结构错误130626 9:14:26 [错误] mysqld:不能find file:' . / performance_schema / file_summary_by_event_name.frm'(errno:13)130626 9:14:26 [ERROR]原生表'performance_schema' . 'file_summary_by_event_name'结构错误130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / file_summary_by_instance.frm'(错误号:13)130626 9:14:26 [错误]本机表'performance_schema' . 'file_summary_by_instance'结构错误130626 9:14:26 [错误] ] mysqld:找不到文件:' . / performance_schema / mutex_instances.frm'(错误号码:13)130626 9:14:26 [错误]原生表'performance_schema' . 'mutex_instances'结构错误130626 9:14: 26 [错误] mysqld:找不到文件:' . / performance_schema / rwlock_instances.frm'(错误号:13)130626 9:14:26 [错误]本机表'performance_schema' . 'rwlock_instances'结构错误130626 9 :14:26 [错误] mysqld:找不到文件:' . / performance_schema / second_instances.frm'(错误号码:13)130626 9:14:26 [错误]原生表'performance_schema' . 'cond_instances'有错误结构130626 9:14:26 [错误] mysqld:找不到文件:' . / performance_schema / file_instances.frm'(错误号:13)130626 9:14:26 [错误]本机表'performance_schema' . 'file_instances'具有错误的结构13062 6 9:14:26 [注意]事件调度程序:已加载0事件130626 9:14:26 [注意] / opt / local / lib / mariadb / bin / mysqld:准备连接 . 版本:'5.5.31-MariaDB'套接字:'/ opt / local / var / run / mariadb / mysqld.sock'端口:0源码分配
mysql通过PHP报告:连接被mysql_error()调用拒绝 . 这已经工作了几个月 . 然后,今天早上,启动我的localhost mysql,没有任何作用 .
编辑:权限似乎很好:
# ls -l /opt/local/var/db/mariadb/performance_schema
total 416
-rw-rw---- 1 root _mysql 8624 Feb 7 14:01 cond_instances.frm
-rw-rw---- 1 root _mysql 61 Feb 7 14:01 db.opt
-rw-rw---- 1 root _mysql 9220 Feb 7 14:01 events_waits_current.frm
-rw-rw---- 1 root _mysql 9220 Feb 7 14:01 events_waits_history.frm
-rw-rw---- 1 root _mysql 9220 Feb 7 14:01 events_waits_history_long.frm
-rw-rw---- 1 root _mysql 8878 Feb 7 14:01 events_waits_summary_by_instance.frm
-rw-rw---- 1 root _mysql 8854 Feb 7 14:01 events_waits_summary_by_thread_by_event_name.frm
-rw-rw---- 1 root _mysql 8814 Feb 7 14:01 events_waits_summary_global_by_event_name.frm
-rw-rw---- 1 root _mysql 8654 Feb 7 14:01 file_instances.frm
-rw-rw---- 1 root _mysql 8800 Feb 7 14:01 file_summary_by_event_name.frm
-rw-rw---- 1 root _mysql 8840 Feb 7 14:01 file_summary_by_instance.frm
-rw-rw---- 1 root _mysql 8684 Feb 7 14:01 mutex_instances.frm
-rw-rw---- 1 root _mysql 8776 Feb 7 14:01 performance_timers.frm
-rw-rw---- 1 root _mysql 8758 Feb 7 14:01 rwlock_instances.frm
-rw-rw---- 1 root _mysql 8605 Feb 7 14:01 setup_consumers.frm
-rw-rw---- 1 root _mysql 8637 Feb 7 14:01 setup_instruments.frm
-rw-rw---- 1 root _mysql 8650 Feb 7 14:01 setup_timers.frm
-rw-rw---- 1 root _mysql 8650 Feb 7 14:01 threads.frm
想法?
1 回答
检查文件所有者和访问权限 . 错误13通常是“许可被拒绝” .