解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误
来源:互联网 发布:百度统计怎么查看数据 编辑:程序博客网 时间:2024/04/29 16:16
[root@centos6Desktop]# ps -ef |grep mysql
root 4635 1 0 15:36 pts/0 00:00:00 /bin/sh/usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql--pid-file=/var/lib/mysql/centos6.pid
mysql 4724 4635 0 15:36 pts/0 00:00:00 /usr/local/mysql/libexec/mysqld--basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql--log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/centos6.pid--socket=/var/lib/mysql/mysql.sock
root 4805 3480 0 15:44 pts/0 00:00:00 grep mysql
得知当前Mysql使用的socket文件的位置
然后在服务器的my.cnf中添加以下
[client]
port=3306
socket=/var/lib/mysql/mysql.sock
Servicemysqld restart
修改root密码
mysqladmin -u rootpassword "Oracle2016"
#########
【mysql version in mysql5.1.73】
- 解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误
- 解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误
- 解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误
- mysql连接错误: Can’t connect to local MySQL server through socket /tmp/mysql.sock
- 记录mysql错误:Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- 解决mysql启动问题: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'错误
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'解决
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'解决
- ERROR 2002: Can't connect to local MySQL server through socket '/tmp/tmp/mysql.sock' (2)
- ERROR 2002: Can't connect to local MySQL server through socket '/tmp/tmp/mysql.sock' (2)
- Django +MySQL Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- mysql运行中问题Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- mysql Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- [mysql]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'
- mysql error 2002 (HY000) : Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- mysql安装出现can't connect to local mysql server through socket /tmp/mysql.sock
- 将本地项目上传至CSDN代码创库
- 第一章作业题
- esxi在终端开启命令行模式
- Spark map 遍历rdd中的每个元素
- CSAPP LAB4 perflab-handout性能优化 smooth负优化详解
- 解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误
- python处理文件tab替换成空格
- Docker学习系列(五):Dockerfile文件
- 第十二周项目 Time类中的运算符重载
- 常用排序算法总结(Java)
- 设计用户界面
- 树
- 希尔排序java版
- Precision和Recall