MySQL启动故障处理一例（errno13） - 数据库编程

d of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 141017 9:28:34 [Note] Plugin 'FEDERATED' is disabled. /usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 141017 9:28:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 141017 9:28:34 InnoDB: The InnoDB memory heap is disabled 141017 9:28:34 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 141017 9:28:34 InnoDB: Compressed tables use zlib 1.2.3 141017 9:28:34 InnoDB: Using Linux native AIO 141017 9:28:34 InnoDB: Initializing buffer pool, size = 128.0M 141017 9:28:34 InnoDB: Completed initialization of buffer pool 141017 9:28:34 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 141017 9:28:34 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 141017 9:28:34 InnoDB: Waiting for the background threads to start 141017 9:28:35 InnoDB: 5.5.39 started; log sequence number 1595668 /usr/libexec/mysqld: File '/data/mysql/mysql_3306/logs/mysql-bin.000004' not found (Errcode: 13) 141017 9:28:35 [ERROR] Failed to open log (file '/data/mysql/mysql_3306/logs/mysql-bin.000004', errno 13) 141017 9:28:35 [ERROR] Could not open log file 141017 9:28:35 [ERROR] Can't init tc log 141017 9:28:35 [ERROR] Aborting
141017 9:28:35 InnoDB: Starting shutdown... 141017 9:28:36 InnoDB: Shutdown completed; log sequence number 1595668 141017 9:28:36 [Note] /usr/libexec/mysqld: Shutdown complete
141017 9:30:32 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 141017 9:30:32 [Note] Plugin 'FEDERATED' is disabled. /usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 141017 9:30:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 141017 9:30:32 InnoDB: The InnoDB memory heap is disabled 141017 9:30:32 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 141017 9:30:32 InnoDB: Compressed tables use zlib 1.2.3 141017 9:30:32 InnoDB: Using Linux native AIO 141017 9:30:32 InnoDB: Initializing buffer pool, size = 128.0M 141017 9:30:32 InnoDB: Completed initialization of buffer pool 141017 9:30:32 InnoDB: highest supported file format is Barracuda. 141017 9:30:32 InnoDB: Waiting for the background threads to start 141017 9:30:33 InnoDB: 5.5.39 started; log sequence number 1595668 /usr/libexec/mysqld: File '/data/mysql/mysql_3306/logs/mysql-bin.000004' not found (Errcode: 13) 141017 9:30:33 [ERROR] Failed to open log (file '/data/mysql/mysql_3306/logs/mysql-bin.000004', errno 13) 141017 9:30:33 [ERROR] Could not open log file 141017 9:30:33 [ERROR] Can't init tc log 141017 9:30:33 [ERROR] Aborting
141017 9:30:33 InnoDB: Starting shutdown... 141017 9:30:34 InnoDB: Shutdown completed; log sequence number 1595668 141017 9:30:34 [Note] /usr/libexec/mysqld: Shutdown complete

现在error.log里很明显地指出errno为13，我们知道13就是权限问题，这个可以perror命令查看 [root@bak mysql]# perror 13 OS error code 13: Permission denied
位置可以通过which来定位 [root@bak mysql]# which perror
/usr/bin/perror
或者用find定位也是可以的 [root

MySQL启动故障处理一例（errno13）(六)