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。備份一般的資料庫沒有問題,但是備份所有的資料庫:
- mysqldump -uroot -p*** -all-database > /home/*****/mysql/backup/alldatabase.sql
備份系統資料庫information_schema.sql:
- 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'ErrorMySql
- MySQL連線提示Can't connect to local MySQL server through socketMySqlServer
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'MySqlServer
- ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sockErrorServerMySql
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- 解決Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) "MySqlServer
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- MySQL 5.5 關閉資料庫報錯"Can't connect to local MySQL server through socket"MySql資料庫Server
- ERROR 2002 (HY000): Can't connect server socket /var/run/mysqld/mysqld.sockErrorServerMySql
- mysql can't connect error about privilege----not root userMySqlError
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)解決方法MySqlServer
- ERROR 2002 (HY000): Cant connect to local MySQL server through socket的解決方法ErrorMySqlServer
- 更換mysql資料目錄後出現ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 的解決辦法MySqlErrorServer
- 異常:Can't connect to MySQL server (10060)MySqlServer
- mysqldump Got error: 1045MySqlGoError
- ERROR 2003 (HY000)Can't connect to MySQL server on '192.168.8.247' (113)ErrorMySqlServer
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)ErrorMySqlServerlocalhost
- 連線MySQL錯誤:Can't connect to MySQL server (10060)MySqlServer
- MySQL 2003 - Can’t connect to MySQL server on (10060)MySqlServer
- mysqldump Got error 1290MySqlGoError
- [jenkins]Can’t connect to window server – not enough permissionsJenkinsServer
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- Navicat 連線 MySQL 失敗:2002-can‘t connect to server on localhost(10061)問題解決MySqlServerlocalhost
- Can't connect to X11 window server usingServer
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- MySQL問題記錄--Can't connect to MySQL server on localhost (10061)解決方法MySqlServerlocalhost
- 【linux】Can't connect to MySQL server on 'XXX' (13)問題解決方式LinuxMySqlServer
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- Can't connect to X11 window server using DISPLAY variableServer
- Can't connect to X11 window server using '127.0.0.1:0.0'Server127.0.0.1
- [ERROR] mysqld: Can‘t open shared library ‘/usr/local/mysql/lib/plugin/validate_password.so‘ (errno:ErrorMySqlPlugin
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- Can't Connect to MySQL Server on IP Address (10061) 錯誤的解決方案MySqlServer
- MySQL不能啟動 Can't start server : Bind on unix sockeMySqlServer
- Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.Server