LinuxSense

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

这样就不会出现找不到连接库文件了
———————————————————————————
mysqld启动不了

[root@philix lib]# /usr/sbin/mysqld 060715 21:16:36 [ERROR] Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root! 060715 21:16:36 [ERROR] Aborting 060715 21:16:36 [Note] /usr/sbin/mysqld: Shutdown complete

解决办法:在/etc/my.conf中的mysqld加入

user=mysql

———————————————————————————————————

[ERROR] Fatal error: Can’t open and lock privilege tables: Table

解决办法

#mysql_install_db