Starting MySQL.The server quit without updating PID file (/var/lib/mysql/TES
报错：
Starting MySQL...The server quit without updating PID file
查看错误日志
情景1：
110206 12:58:35 [ERROR] Can't start server : Bind on unix socket: No such file or directory
110206 12:58:35 [ERROR] Do you already have another mysqld server running on socket: /mysql/mysqldir/data/mysql.sock ?
110206 12:58:35 [ERROR] Aborting
于是ps -ef | grep mysql 一把.未发现有mysqld.
netstat -an | grep 3306 一把.也未发现异常.
最后从mysql安装目录下重新复制一个配置文件到/etc/my.cnf
修改相应参数.于是问题解决
情景2：
/mysql/mysqldir/bin/mysqld: Table 'mysql.plugin' doesn't exist
[ERROR] Can't open the mysql.plugin table. Please run my sql_upgrade to create it.
原因：编译安装后忘记初始化表.
解决：运行mysql_install_db
阅读(829) | 评论(0) | 转发(0) |
