• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    mysql服务启动却连接不上的解决方法

    mysql服务启动,但是连接不上,如何解决?

    登陆报错:

      root@localhost:~# mysql -u root -p
      Enter password:
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
      root@localhost:~# service mysqld restart
      Shutting down MySQL..                   [ OK ]
      Starting MySQL.                      [ OK ]
      root@localhost:~# mysql -u root -p
      Enter password:
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    

    分析原因:

    原因不详,知道了补上

    解决方案一:

     root@localhost:~# find / -name mysql.sock
     /tmp/mysql.sock
     root@localhost:~# mysql -u root -p -S /tmp/mysql.sock
     Enter password:
     Welcome to the MySQL monitor. Commands end with ; or \g.
     Your MySQL connection id is 1
     Server version: 5.6.15-log Source distribution
    
     Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
    
     Oracle is a registered trademark of Oracle Corporation and/or its
     affiliates. Other names may be trademarks of their respective
     owners.
    
     Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
     mysql>
    
    

    解决方案二:

     root@localhost:~# find / -name mysql.sock
     /tmp/mysql.sock
     root@localhost:~# vi /etc/my.cnf
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1
    
    # Disabling symbolic-links is recommended to prevent assorted security risks;
    # to do so, uncomment this line:
    # symbolic-links=0
    
    # 加上下面的这段代码即可
    [mysql]
    socket=/tmp/mysql.sock
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    
    root@localhost:~# mysql -u root -p
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 3
    Server version: 5.6.15-log Source distribution
    
    Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql>
    
    

    以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持脚本之家。

    您可能感兴趣的文章:
    • MySQL启动连接的命令以及与PHP程序连接的基本语法
    • 详解Ubuntu Server下启动/停止/重启MySQL数据库的三种方式
    • Mysql启动的方式(四种)
    • Ubuntu自启动Mysql的三种方式
    • php中mysql连接方式PDO使用详解
    • 用 Python 连接 MySQL 的几种方式详解
    • 总结MySQL修改最大连接数的两个方式
    • php连接MySQL的两种方式对比
    • php+mysqli数据库连接的两种方式
    • MySql二进制连接方式详解
    • PHP连接MySQL数据库的三种方式实例分析【mysql、mysqli、pdo】
    • MySQL 的启动和连接方式实例分析
    上一篇:mysql取得datetime类型的数据,后面会跟个.0的实现方法
    下一篇:MySQL 触发器详解及简单实例
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

    mysql服务启动却连接不上的解决方法 mysql,服务,启动,却,连接,