ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
来源:互联网 发布:广联达预算软件试用版 编辑:程序博客网 时间:2024/06/13 04:59
今天重启了一下Linux服务器,突然发现Mysql连接不上了。
输入:mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
就报错......可找死人了!
后来发现系统中有两个my.cnf文件
打开/etc目录发现my.cnf文件...
打开/etc/mysql目录下面还有一个my.cnf文件....
输入命令:mv /etc/mysql/my.cnf /etc/mysql/my.cnf.old
把/etc/mysql/my.cnf重命名成my.cnf.old
然后:service mysqld start
就能正常运行了....
我就不懂了,为什么会有两个my.cnf文件呢!奇怪!
0 0
- MySQL ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- 重启linux 命令
- PHPExcel导出大量数据超时及内存错误解决方法
- Python 基础语法(1)
- 分析linux中断源码初始化
- SQL优化----dbms_sqltune详解(1)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- ant安装
- java toString方法
- Android屏幕适配经验谈
- 解决JSP网站开发中的驱动冲突问题
- 分布式系统与一致性协议
- what's the function of pid file?
- ACM GVIM配置 在windows/linux 快捷键
- SHOPNC所有分类代码简化版