虚位以待(AD)
虚位以待(AD)
首页 > 数据库 > Mysql数据库 > mysql服务启动却连接不上的解决方法

mysql服务启动却连接不上的解决方法
类别:Mysql数据库   作者:码皇   来源:互联网   点击:

这篇文章主要为大家详细介绍了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/mysqlsocket=/var/lib/mysql/mysql.sockuser=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.logpid-file=/var/run/mysqld/mysqld.pidroot@localhost:~# mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ;
    or g.Your MySQL connection id is 3Server version: 5.6.15-log Source distributionCopyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;
    ' or 'h' for help. Type 'c' to clear the current input statement.mysql>

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

相关热词搜索: mysql服务启动 mysql连接不上 mysql服务启