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

2024-07-24 12:52:06

字体：大中小

来源：转载

供稿：网友

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>

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持错新站长站。

您可能感兴趣的文章:

利用Prometheus与Grafana对Mysql服务器的性能监控详解Mysql5.7服务无法启动的图文解决教程MySQL使用innobackupex备份连接服务器失败的解决方法mysql运行net start mysql报服务名无效的解决办法MySQL使用show status查看MySQL服务器状态信息mysql自动定时备份数据库的最佳方法(windows服务器)查看linux服务器上mysql配置文件路径的方法MySql服务未知原因消失解决方法

上一篇：MySQL 触发器详解及简单实例

下一篇：mysql取得datetime类型的数据,后面会跟个.0的实现方法