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

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

最近在学习逻辑备份--mysqldump。备份一般的数据库没有问题，但是备份所有的数据库：

1. mysqldump -uroot -p*** -all-database > /home/*****/mysql/backup/alldatabase.sql

备份系统数据库information_schema.sql:

1. mysqldump -uroot -p information_schema > /home/*****/mysql/backup/information_schema.sql

都会报同样的错误，如下：

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

解决方法：

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26435490/viewspace-1299651/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26435490/viewspace-1299651/