mysql服务启动却连接不上两种解决办法
程序员文章站
2022-04-14 22:41:15
...
这篇文章主要为大家详细介绍了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服务启动却连接不上两种解决办法的详细内容,更多请关注其它相关文章!
上一篇: sql添加数据后返回受影响行数据
下一篇: php中把数组写入到文件,再读取
推荐阅读
-
阿里旺旺显示正在连接服务器很长时间登录不上的解决办法
-
MAC下MYSQL5.7.17连接不上的问题及解决办法
-
阿里旺旺显示正在连接服务器很长时间登录不上的解决办法
-
mysql服务启动却连接不上的解决方法
-
MAC下MYSQL5.7.17连接不上的问题及解决办法
-
navicat连接不上linux服务器上的mysql的解决办法
-
Workbench连接不上阿里云服务器Ubuntu的Mysql解决方法(已测)
-
mysql服务启动却连接不上的解决方法
-
#1045无法登录phpmyadmin,连接不上mysql服务器,先把ubuntu安装
-
#1045无法登录phpmyadmin,连接不上mysql服务器,先把ubuntu安装