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
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
- mysqldump: Got error: 2002: Can't connect to local MySQL server through socket
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql
- Mysql error 2002 (HY000) : Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- mysql error 2002 (HY000) : Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/mysql/mysql.sock' (2)
- ERROR 2002: Can't connect to local MySQL server through socket '/tmp/tmp/mysql.sock' (2)
- ERROR 2002: Can't connect to local MySQL server through socket '/tmp/tmp/mysql.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var mysql连不上
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var mysql 启动不了
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var mysql 启动不了
- java之泛型
- YOLO 训练VOC数据集
- 利息计算器(C#)
- [翻译]C++20新运算符之三元比较符<=>
- 啥,又要为表增加一列属性?
- mysqldump: Got error: 2002: Can't connect to local MySQL server through socket
- Java基础学习总结(122)——Java八种基本数据类型的包装类及其装箱拆箱详解
- NLP汉语自然语言处理原理与实践 3 词汇与分词技术
- 这才是真正的表扩展方案
- Hadoop视频教程汇总
- Python常用的内置函数
- java动态代理
- CreateRemoteThread在有些电脑上注入的Dll不执行原因
- Apache和Tomcat整合(一个Apache 不同域名处理多个不同业务) tomcat-connectors-1.2.41-src.tar.gz