控制台异常：
Starting MySQL....The server quit without updating PID file (/data2/mysql/SMT-TDB01.pid).[失败]
?
日志文件记录：
130121 11:52:47 mysqld_safe Starting mysqld daemon with databases from /data2/mysql
130121 11:52:47 [Note] Plugin 'FEDERATED' is disabled.
130121 11:52:47 InnoDB: The InnoDB memory heap is disabled
130121 11:52:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130121 11:52:47 InnoDB: Compressed tables use zlib 1.2.3
130121 11:52:47 InnoDB: Using Linux native AIO
/usr/sbin/mysqld: Can't create/write to file '/data2/tmp/ibeWc2qS' (Errcode: 2)
130121 11:52:47? InnoDB: Error: unable to create temporary file; errno: 2
130121 11:52:47 [ERROR] Plugin 'InnoDB' init function returned error.
130121 11:52:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130121 11:52:47 [ERROR] Unknown/unsupported storage engine: InnoDB
130121 11:52:47 [ERROR] Aborting
130121 11:52:47 [Note] /usr/sbin/mysqld: Shutdown complete
130121 11:52:47 mysqld_safe mysqld from pid file /data2/mysql/SMT-TDB01.pid ended
?
重点是红色部分,意思就是对'/data2/tmp/目录可能没有创建和写入的权限
?
解决方法
1,检查此目录是否存在，不存在则创建
2,对此文件添加 mysql访问的权限：chown -R mysql:mysql /data2/tmp
?