Linux ERROR 2002 (HY000): Can't connect to local MySQL server through socket和 Couldn't find MySQL se
来源:互联网 发布:网络安全管理责任书 编辑:程序博客网 时间:2024/05/29 16:39
Linux环境,通过mysql -uroot -p命令进入mysql的时候,总是报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket
通过service mysqld restart 重启mysql,也是报错“ Couldn't find MySQL server (/usr/bin/mysqld_safe)”
之前我在安装的时候,mysql自定义了安装路径,my.cnf的配置都已经设置好了。但是这次想再进入mysql和重启mysql的时候,都出现了问题。于是
找到my.cnf文件,进行查看:
结果发现我的my.cnf文件有两个。在/etc/mysql这个目录下的my.cnf是之前删除的数据库的配置文件,新mysql用的配置文件是/etc/my.cnf,
而/etc/mysql这个里面的my.cnf文件的配置都是之前删除数据库的配置,所以讲这个my.cnf文件删除或者改名,则问题解决
阅读全文
0 0
- Linux ERROR 2002 (HY000): Can't connect to local MySQL server through socket和 Couldn't find MySQL se
- 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 '/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 '/mysql/mysql.sock' (2)
- 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' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
- 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' (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 ‘/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 '/tmp/mysql.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- Node.js 介绍文章
- 记录一次,三次握手中缺少第二次握手导致的问题(即缺少SYN ACK返回,实际是tcp_tw_recycle设置导致的问题)
- 一款很好用的,免费的外网映射工具Ngrok 国内版,可以满足基本的开发测试需求
- AS基本快捷键
- 写给小白的编程入门Tips
- Linux ERROR 2002 (HY000): Can't connect to local MySQL server through socket和 Couldn't find MySQL se
- 迷之阶梯(动态规划)
- Spring Boot打jar包时指定main方法入口
- Java并发编程:CountDownLatch、CyclicBarrier和Semaphore
- thread相关——读写锁
- eclipse中tomcat远程调试服务器
- 用到的Elasticsearch相关的笔记
- 一些实战中用到的类库总结
- 动态规划F