wudong333 发表于 2011-3-6 18:05:27

MYSQL启动时提示错误

我重启了VPS,网站无法访问了,我以为是LNMP没启动,就启动LNMP(不知道重启VPS需要手动启动LNMP吗?操作系统: Centos 5 32bit ),启动完成最后一行提示MYSQL有错误。
麻烦看看是什么问题,谢谢了:handshake

查看lnmp状态其实错误:
Nginx is runing!
ERROR! MySQL is running but PID file could not be found


启动MYSQL提示下面错误:
ERROR! Manager of pid-file quit without updating file。

下面是错误日志文件:
110306 09:43:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110306 09:45:14 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1103069:45:43 Event Scheduler: Loaded 0 events
1103069:45:43 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
1103069:47:54 Can't start server: Bind on TCP/IP port: Address already in use
1103069:47:54 Do you already have another mysqld server running on port: 3306 ?
1103069:47:54 Aborting

1103069:52:29 /usr/local/mysql/libexec/mysqld: Shutdown complete

110306 09:52:41 mysqld_safe mysqld from pid file /usr/local/mysql/var/gpcj.info.pid ended
110306 17:14:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110306 17:14:49 Can't start server: Bind on TCP/IP port: Address already in use
110306 17:14:49 Do you already have another mysqld server running on port: 3306 ?
110306 17:14:49 Aborting

110306 17:14:49 /usr/local/mysql/libexec/mysqld: Shutdown complete

110306 17:14:49 mysqld_safe mysqld from pid file /usr/local/mysql/var/gpcj.info.pid ended
110306 17:42:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110306 17:42:07 Can't start server: Bind on TCP/IP port: Address already in use
110306 17:42:07 Do you already have another mysqld server running on port: 3306 ?
110306 17:42:07 Aborting

110306 17:42:07 /usr/local/mysql/libexec/mysqld: Shutdown complete

110306 17:42:07 mysqld_safe mysqld from pid file /usr/local/mysql/var/gpcj.info.pid ended

[ 本帖最后由 wudong333 于 2011-3-6 18:09 编辑 ]

licess 发表于 2011-3-7 09:18:59

回复 1# 的帖子

已经有其他的mysql在运行,ps aux看一下,kill那个进程id,再启动试试
页: [1]
查看完整版本: MYSQL启动时提示错误