linux系统上启动mysql报错2002:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/l
来源:互联网 发布:网络语言暴力的定义 编辑:程序博客网 时间:2024/06/08 04:59
在Linux上登录mysql时出现了下面的错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
启动mysql时报错:
Starting MySQL.The server quit without updating PID file (/[FAILED]mysql/iZ2ze8us9p89pd5wd2bfffZ.pid).
这个问题一直找不到什么原因,应为初学linux,很多东西都不懂,在网上也查了很久,最后找到了解决方法,给大家分享下
使用“ln -s /storage/db/mysql/mysql.sock /var/lib/mysql/mysql.sock”命令,将正确的socket文件位置,软链接到提示错误的socket文件路径位置,即可解决此问题:
[root@aiezu.com ~]
# ls /var/lib/mysql/mysql.sock
ls
: cannot access
/var/lib/mysql/mysql
.sock: No such
file
or directory
[root@aiezu.com ~]
# ln -s /storage/db/mysql/mysql.sock /var/lib/mysql/mysql.sock
[root@aiezu.com ~]
# ls /var/lib/mysql/mysql.sock
/var/lib/mysql/mysql
.sock
阅读全文
0 0
- linux系统上启动mysql报错2002:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/l
- 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 启动不了
- 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 启动不了
- MySQL启动时报错:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/my
- Linux上mysql登陆错误解决办法ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/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
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run
- 解决:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run
- mysql ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.s
- [MySQL] 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 '/var/lib/mysql/mysql.
- [MySQL] ERROR 2002(HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.
- 跟着示例学Oozie
- HP elitebook 840 G3 蓝牙无法使用问题 + 触摸板无法关闭
- DES算法简介及android中的实现
- Spring注解详解
- 使用eclipse提交项目到GitHub
- linux系统上启动mysql报错2002:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/l
- Json转模型1--SwiftyJson
- 统计学学习笔记——(5)归一化
- java不重启服务动态加载properties文件
- JavaScript类型转换规则
- 暗影精灵3开机黑屏解决方案
- android学习之边框及阴影
- 三级菜单拖拽排序,各级互不影响,理论上可以无限级菜单
- onActivityResult和putExtra的用法