找回密码
 注册
查看: 503|回复: 0

ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/my

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2023-5-15 13:00:00 | 显示全部楼层 |阅读模式
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (111)
# @; o, V$ X, |- j6 z) c( G  138  vim /etc/mysql/my.cnf
8 B( ?2 N' k& \% w  139  vim /etc/mysql/conf.d/mysql.cnf
4 K7 e9 e+ L( {3 `! n  140  vim /etc/mysql/conf.d/mysqldump.cnf
3 \) K& {& E! a1 O- {+ r  141  vim /etc/mysql/debian.cnf
% ?% U  }: z4 H8 K4 l  142  vim /etc/mysql/mariadb.conf.d/50-client.cnf & W7 h8 g5 u- T3 Y
  143  vim /etc/mysql/mariadb.conf.d/50-mysql-clients.cnf : y6 S6 F0 [. N8 T' _
  144  vim /etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf " N3 U; y  q2 _  [+ l
  145  vim /etc/mysql/mariadb.conf.d/50-server.cnf - X4 G) s+ D% q9 P  F: s
  146  vim /etc/mysql/mariadb.conf.d/60-galera.cnf
# r* [5 k. }8 Q5 |  147  vim /etc/mysql/mariadb.conf.d/99-openstack.cnf
; M# U. m1 F# |  ~
2 E8 C: F$ j0 [" r5 F: V8 d. W( G$ H  T0 N
修改检查是否存在多个socket配置文件,删除其他文件的socket。保留vim /etc/mysql/my.cnf文件中的socket配置:
6 |" z" Z" j! M% a$ a' Z
% c6 E0 F6 P# N+ ?  o: M4 |重启mairadb数据,即可。: z+ D, y: r  \! t5 Z" C) \
' O  r0 p. V- i  \* I3 O) M# @
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-11 23:05 , Processed in 0.019548 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表