解决：Starting MySQL....The server quit without updating PID file

控制台异常：

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