mysqldump: Got error: 2002: Can't connect to local MySQL server through socket

来源:互联网 发布:网络打假 编辑:程序博客网 时间:2024/06/17 20:05

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

在执行mysqldump命令时候报如下错误:
nano@nano:~$ mysqldump -uroot -p test > test.sql
Enter password: 
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect

找到正确的套接字的路径: 
nano@nano:~$ netstat -ln | grep mysql
unix  2      [ ACC ]     流        LISTENING     60076    /tmp/mysql.sock


再运行dump命令:
nano@nano:~$ mysqldump --socket=/tmp/mysql.sock -uroot -p test > test.sql

执行成功

阅读全文
0 0
原创粉丝点击