MySQL常见错误解决方法

错误提示:
InnoDB: Unable to lock ./ibdata1, error: 11
解决:
ps -ef|grep mysqld ,杀死僵死进程

然后重新启动mysql

---------------------------------------------------------------------------------

错误提示:
error while loading shared libraries: libssl.so.0.9.8:

解决:
更新db,openssl


pacman -S db ,openssl


这样就不会出现找不到连接库文件了
---------------------------------------------------------------------------------

Continue reading...

MySQL. ERROR! The server quit without updating PID file

错误日志内容大概为
130714 04:26:48 mysqld_safe Starting mysqld daemon with databases from /disk/database
130714 4:26:48 InnoDB: The InnoDB memory heap is disabled
130714 4:26:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130714 4:26:48 InnoDB: Compressed tables use zlib 1.2.3
^G/usr/local/mysql/bin/mysqld: Can't create/write to file '/tmp/ibfvDbsy' (Errcode: 13)
130714 4:26:48 InnoDB: Error: unable to create temporary file; errno: 13
130714 4:26:48 [ERROR] Plugin 'InnoDB' init function returned error.
130714 4:26:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130714 4:26:48 [ERROR] Unknown/unsupported storage engine: InnoDB
130714 4:26:48 [ERROR] Aborting
在阿里云服务器中,出现这个问题比较平常。

在后来试过的方法中,以为是data目录无法进行写入权限。
尝试过比较多方法都无效。

尝试更改tmp权限解决

# chown -R mysql:mysql /tmp/

有时候感觉sun公司的报划机制会误导我们。

Continue reading...



about me

  • 陶之11's Blog Name:陶之11 OICQ:14779023 Site:Pao11.com

分类

快捷入口