MySql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
来源:互联网 发布:js中怎么格式化日期 编辑:程序博客网 时间:2024/05/30 02:23
今天突然就遇到了Mysql登录不上,报错
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)
- 打开mysql workbench,发现所有库都没有连接
- (我用的mac)在设置里看了一下,mysql server没有启动,启动mysql server失败!
- 接3,仔细一看,有个警告
Warnning:the /usr/local/mysql/data directory is not owned by the mysql
如图 - 问题就出在这,我不久前改了
/usr/local
宿主…. 6.
解决:
$ sudo chown -R mysql /usr/local/mysql/data
阅读全文
0 0
- 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 '/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 '/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 '/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 '/tmp/mysql.sock' (2)
- 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 '/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' (111)
- Linux-星星之火
- ViewPager里Fragment跳转Activity,返回刷新Fragment
- 《机器学习》笔记——神经网络
- Mac JDK1.7下载
- table a
- MySql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- centos7为用户添加root权限
- 自媒体平台:大鱼计划,20亿大鱼平台奖励金如何获取?
- SpringCloud(第 043 篇)链接Mysql数据库简单的集成Mybatis框架访问数据库
- mybatis一对多(二)
- The JRE could not be found.Edit the server and change the JRE location.
- 前端性能优化常见方法
- Redis在windows下安装过程
- Eclipse连接hbase并实现简单表的建立