VPS侦探论坛

 找回密码
 注册
查看: 7657|回复: 1

MYSQL启动时提示错误

[复制链接]
发表于 2011-3-6 18:05:27 | 显示全部楼层 |阅读模式

我重启了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 编辑 ]
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2011-3-7 09:18:59 | 显示全部楼层

回复 1# 的帖子



已经有其他的mysql在运行,ps aux看一下,kill那个进程id,再启动试试
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-12-23 18:54 , Processed in 0.025539 second(s), 17 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表