Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
来源:互联网 发布:linux 退出编辑命令 编辑:程序博客网 时间:2024/06/06 08:32
在mysql主机上使用bin/mysql -hlocalhost -uroot -p 连接mysql数据库,一直报 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock',按照网上的配置方法,在my.cnf增加以下配置:
[mysql]socket=/usr/...../mysql.sock[client]socket=/usr/...../mysql.sock
连接的时候依旧报这个错误,这种连接方式使用了默认的3306端口,由于我的端口号改成其他的了,所以需要指定端口号。还可以指定socket文件位置来连接mysql,比如:
bin/mysql -uroot -p --socket=/usr/...../mysql.sock --port=3358
这样一般不会出错。
阅读全文
0 0
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ mysql.sock
- mysql启动Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- eoiioe Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’解决方法
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) 问题解决
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Can 't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '(2) ";
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’问题
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- 对ffmpeg的时间戳的理解笔记
- SpringMVC整合JPA
- INFP职业规划,誓要用“12分努力”来捍卫家庭的31岁INFP女孩
- 分析 ddp gamma 模块
- kNN算法
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
- linux学习第九篇:特殊权限set_uid,set_gid,stick_bit以及软连接文件,硬链接文件
- TabLayout的基本使用
- Swift 3.0 集成极光推送
- java单例设计模式--饿汉模式
- Java中装饰者模式与代理模式的使用
- express cook 操作
- Handler三秒更换图片
- 集合框架