mysql使用中mysqld.sock can't find
来源:互联网 发布:演唱会望远镜 知乎 编辑:程序博客网 时间:2024/05/21 21:01
问题现象:
mysql -u root -p
Enter password:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory")
原因:
1、你的mysql.servic可以没有打开
2、mysqld.sock所在文件的用户权限问题
解决方法:
1、查找mysqld.sock文件,sudo / find mysqld.sock 查看文件目录如果找到,参考方法http://www.2cto.com/database/201504/387956.html。
2、如果没找到文件那么很有可能是原因1,使用如下命令解决:sudo systemctl start mysqld(这里是你的mysql服务器)
3、如果想明白原理参考https://wiki.archlinux.org/index.php/MySQL
0 0
- mysql使用中mysqld.sock can't find
- can't start mysqld on centos because I cant find mysql.sock
- mysql中can't find mysql.sock 问题解决
- Mysql连接的过程中出现Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
- Xampp使用mysql命令提示Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- 04-MySQL-Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)解决办法
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'解决
- error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
- Error:2002:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- 正则表达式从入门到精通
- FleaPHP和ThinkPHP(比较)
- 博客
- 务必一定好C语言!——必须的 (转载)
- vb.net 教程 1-6 数据类型:数值数据转换 1
- mysql使用中mysqld.sock can't find
- JavaFX简单入门(IDE 6.8 for JavaFX 1.2)
- 正则匹配简单入门
- 代码笔记:caffe-reid自己增加的caffe.proto
- 常见内存错误【转载】
- 关于如何查询本机详细的系统信息
- HTTP 错误
- socket原理【转载】
- SSL协议原理(Secure Socket Layer)【转载】