MYSQL启动时提示错误

wudong333

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

查看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
110306  9:45:43 [Note] Event Scheduler: Loaded 0 events
110306  9:45:43 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
110306  9:47:54 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
110306  9:47:54 [ERROR] Do you already have another mysqld server running on port: 3306 ?
110306  9:47:54 [ERROR] Aborting

110306  9:52:29 [Note] /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 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
110306 17:14:49 [ERROR] Do you already have another mysqld server running on port: 3306 ?
110306 17:14:49 [ERROR] Aborting

110306 17:14:49 [Note] /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 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
110306 17:42:07 [ERROR] Do you already have another mysqld server running on port: 3306 ?
110306 17:42:07 [ERROR] Aborting

110306 17:42:07 [Note] /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

已经有其他的mysql在运行，ps aux看一下，kill那个进程id，再启动试试