VPS侦探论坛

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

MYSQL死活不能启动

[复制链接]
发表于 2012-3-6 02:36:42 | 显示全部楼层 |阅读模式

CENTOS+LNMP 0.8
前台报错:[2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


尝试了多种方法,权限、磁盘空间MYSQL.SOCK等等,均为解决。

提示已经启动,查看进程并没有,KILL掉进程重启LNMP、root均无效,没办法了,特来求救!!
以下是

MYSQL错误日志:
  1. 120306 01:38:25 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  2. 120306  1:38:25 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
  3. 120306  1:38:25 [ERROR] Do you already have another mysqld server running on port: 3306 ?
  4. 120306  1:38:25 [ERROR] Aborting

  5. 120306  1:38:25 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

  6. 120306 01:38:25 mysqld_safe mysqld from pid file /usr/local/mysql/var/sserver101.pid ended
  7. 120306 01:39:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  8. 120306  1:39:59 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
  9. 120306  1:39:59 [ERROR] Do you already have another mysqld server running on port: 3306 ?
  10. 120306  1:39:59 [ERROR] Aborting

  11. 120306  1:39:59 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

  12. 120306 01:39:59 mysqld_safe mysqld from pid file /usr/local/mysql/var/sserver101.pid ended
  13. 120306 01:43:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  14. 120306  1:43:18 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
  15. 120306  1:43:18 [ERROR] Do you already have another mysqld server running on port: 3306 ?
  16. 120306  1:43:18 [ERROR] Aborting

  17. 120306  1:43:18 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

  18. 120306 01:43:18 mysqld_safe mysqld from pid file /usr/local/mysql/var/sserver101.pid ended
  19. 120306 01:59:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  20. 120306  1:59:08 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
  21. 120306  1:59:08 [ERROR] Do you already have another mysqld server running on port: 3306 ?
  22. 120306  1:59:08 [ERROR] Aborting

  23. 120306  1:59:08 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

  24. 120306 01:59:08 mysqld_safe mysqld from pid file /usr/local/mysql/var/sserver101.pid ended
  25. 120306 02:02:38 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  26. 120306  2:02:38 [Note] Event Scheduler: Loaded 0 events
  27. 120306  2:02:38 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
  28. Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3307  Source distribution
  29. 120306  2:09:35 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

  30. 120306  2:09:35 [Note] Event Scheduler: Purging the queue. 0 events
  31. 120306  2:09:35 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

  32. 120306 02:09:35 mysqld_safe mysqld from pid file /usr/local/mysql/var/sserver101.pid ended
  33. 120306 02:09:41 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  34. 120306  2:09:42 [Note] Event Scheduler: Loaded 0 events
  35. 120306  2:09:42 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
  36. Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3307  Source distribution
复制代码
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2012-3-6 12:13:38 | 显示全部楼层


已经有其他的非lnmp的mysql在运行。
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2024-11-16 20:51 , Processed in 0.025578 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

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