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

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

[复制链接]

0

主题

0

回帖

9

积分

管理员

积分
9
QQ
发表于 2023-5-15 13:00:00 | 显示全部楼层 |阅读模式
ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (111)
- W3 |# {) ]3 K3 a# K1 ?0 o  138  vim /etc/mysql/my.cnf' f+ K; b/ B) {( t/ R
  139  vim /etc/mysql/conf.d/mysql.cnf ( @7 m8 g( m  q
  140  vim /etc/mysql/conf.d/mysqldump.cnf 7 N, O* u5 B0 f/ e
  141  vim /etc/mysql/debian.cnf ( O6 u* `2 S% V% ^5 @+ q! S6 w) U
  142  vim /etc/mysql/mariadb.conf.d/50-client.cnf
7 {/ g+ M/ r& K; ~1 x/ R  143  vim /etc/mysql/mariadb.conf.d/50-mysql-clients.cnf 7 s+ }/ s8 S2 L9 z% _, p! M
  144  vim /etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf ; c. B$ D* p6 Q: L
  145  vim /etc/mysql/mariadb.conf.d/50-server.cnf 2 A' `  L& W' W7 c' w+ O
  146  vim /etc/mysql/mariadb.conf.d/60-galera.cnf
4 @* u( w1 P6 {' `# M  147  vim /etc/mysql/mariadb.conf.d/99-openstack.cnf
: e  h- W# y7 [7 l; J& G/ r: b! I3 v- s8 {3 m! p  a# Z

! C7 c1 P/ p1 ]' b9 O  w; z/ e修改检查是否存在多个socket配置文件,删除其他文件的socket。保留vim /etc/mysql/my.cnf文件中的socket配置:1 j0 l- o0 p5 \; ^& [3 D8 i

' W) Z; M0 X# z; S! d: e; D/ Z3 [重启mairadb数据,即可。# z0 A3 u  J& ~% x/ a" c+ k
1 D! n2 C5 {4 r3 Y, x
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2026-6-11 22:58 , Processed in 0.021544 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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