Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
来源:互联网 发布:淘宝口令怎么用 编辑:程序博客网 时间:2024/06/05 09:05
MySQL自定义了mysql.sock和data文件位置以后,重启如果my.cnf配置不完整会导致如下:
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when trying to connect
或者
mysqladmin: Got error: xxxx: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when trying to connect
或者
mysql: Got error: xxxx: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when trying to connect
需要在my.cnf中告诉这些可执行文件sock在哪,:
[mysql]
socket=/usr/local/web/data/mysql.sock
[mysqladmin]
socket=/usr/local/web/data/mysql.sock
[mysqldump]
socket=/usr/local/web/data/mysql.sock
重启MySql就可以了
阅读全文
0 0
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ mysql.sock
- mysql启动Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- eoiioe Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’解决方法
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) 问题解决
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Can 't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '(2) ";
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’问题
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- 了解负载均衡 会话保持 session同步(转)
- listview与adapter用法
- Codeforces 748 E Santa Claus and Tangerines
- Xcode9通过Wifi连接设备进行调试
- C++11中的delete关键字
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- 类模版之偏特化
- ios上跳转app的方法,跳转到appstore等系统应用的方法
- springmvc如何设置多视图器,springmvc 多个 ViewResolver
- HTML BASIC
- 调用另外一个带环境变量的系统并最大化
- 循环中fork创建进程的个数
- git revert
- Linux下编译并运行C程序