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
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
执行成功