找回密码
 注册
查看: 505|回复: 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/ A! B9 `1 M# o! N7 C) p5 g. U  138  vim /etc/mysql/my.cnf
2 O5 F2 X3 o/ A7 F& u' w  139  vim /etc/mysql/conf.d/mysql.cnf
4 s5 d( P* X( t) s  140  vim /etc/mysql/conf.d/mysqldump.cnf 7 @5 G, H7 w' g1 v5 h
  141  vim /etc/mysql/debian.cnf
1 ^! u' b/ s% t; B6 m! [  142  vim /etc/mysql/mariadb.conf.d/50-client.cnf % a/ g, d; K# R1 s+ Z1 z
  143  vim /etc/mysql/mariadb.conf.d/50-mysql-clients.cnf + ?" ~; J8 H$ P$ D" }4 D1 W
  144  vim /etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf ; o) t! g& K* e! `
  145  vim /etc/mysql/mariadb.conf.d/50-server.cnf
- R7 J( P/ x2 ^9 J% N1 l  146  vim /etc/mysql/mariadb.conf.d/60-galera.cnf
/ x7 @0 ?2 L2 q& v2 F  147  vim /etc/mysql/mariadb.conf.d/99-openstack.cnf ! ?9 I' T; j) L$ w; R7 r

1 f8 r% }* Z( b0 M) g' D  g- ~8 y' f3 B" w' u8 x; r
修改检查是否存在多个socket配置文件,删除其他文件的socket。保留vim /etc/mysql/my.cnf文件中的socket配置:
0 W9 q$ b& N) B4 K' {( ]/ M$ e8 E' v; E2 u/ z: V! ]
重启mairadb数据,即可。% d9 l2 K+ r# `( X; L
" s4 o( b& V3 ]7 S
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2026-6-12 00:06 , Processed in 0.018232 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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