mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" when trying to connect

  • netstat -ln | grep mysql查看mysql.sock实际路径:
[root@localhost backup]# netstat -ln | grep mysql
unix  2      [ ACC ]     STREAM     LISTENING     62019    /tmp/mysql.sock
  • 创建软链

ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

posted @ 2022-10-25 10:54  秒年度  阅读(698)  评论(0编辑  收藏  举报