› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
lm902
V2EX  ›  MySQL

MySQL不能连接怎解

  •  
  •   lm902 ·
    lm902 · Feb 12, 2014 · 4781 views
    This topic created in 4652 days ago, the information mentioned may be changed or developed.
    [root@akumangel ~]# mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    [root@akumangel ~]# /etc/init.d/mysqld restart
    Stopping mysqld: [ OK ]
    Another MySQL daemon already running with the same unix socket.
    Starting mysqld: [FAILED]
    [root@akumangel ~]#
    9 replies  •  1970-01-01 08:00:00 +08:00
    Livid
    Livid
    MOD
    PRO
    Feb 12, 2014❤️1
    1
    kill 之后再启动一次试试。
    lm902
    lm902
    OP
    Feb 12, 2014
    2
    @Livid 貌似把/var/lib/mysql/mysql.sock删除就好了,可能是因为最近非正常关机过,MySQL一直以为自己正在运行
    4gShell
    4gShell
    Feb 12, 2014
    3
    虽然我对linux不太懂,但是我从你的信息可以读出,你必须终结那个已经存在的socket
    lm902
    lm902
    OP
    Feb 12, 2014
    4
    Linux各种不会用。。。还是用回Windows Server吧。。。
    xzl
    xzl
    Feb 12, 2014
    5
    @4gShell 字里行间没有任何提示说要终结那个已经存在的socket,得找出为什么存在,光这个就有3个情况: 1如楼主异常关闭, 来不及删除;2已有一个mysql实例在正常运行;3该磁盘分区文件系统损坏文件只读删不掉socket。
    4gShell
    4gShell
    Feb 12, 2014
    6
    @xzl nice,我的意思比较模式,见笑了。
    VYSE
    VYSE
    Feb 12, 2014
    7
    /var/log/mysql 看error log mysql之前crash了
    zencoding
    zencoding
    Feb 12, 2014
    8
    强制终止掉进程,再重启
    fanpenghua
    fanpenghua
    Feb 13, 2014
    9
    最近老这样,问题不大。主要是出问题及时处理掉
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   808 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 37ms · UTC 17:23 · PVG 01:23 · LAX 09:23 · JFK 12:23
    ♥ Do have faith in what you're doing.