Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'解决
来源:互联网 发布:linux系统加固 编辑:程序博客网 时间:2024/05/21 09:07
安装上mysql后,报 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock',试了网上的方法都没有用,于是打开/etc/my.cnf查看。
看到这么一段:
# The MySQL server
26 [mysqld]
27 port = 3306
28 socket = /tmp/mysql.sock
29 skip-external-locking
30 log-error=/alidata/log/mysql/error.log
31 key_buffer_size = 16M
32 max_allowed_packet = 1M
33 table_open_cache = 64
34 sort_buffer_size = 512K
35 net_buffer_length = 8K
36 read_buffer_size = 256K
37 read_rnd_buffer_size = 512K
38 myisam_sort_buffer_size = 8M
可知,使用的.sock文件,是/tmp/mysql.sock,而不是/var/run/mysqld/mysqld.sock,于是加个链接
ln -s /tmp/mysql.sock /var/run/mysqld/mysqld.sock
问题解决
0 0
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'的解决
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'解决
- 04-MySQL-Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)解决办法
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
- Error:2002:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)问题解决
- xampp的mysql --》Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'解决
- 解决mysql的Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock
- MySQL ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- Linux连接MySQL时的错误:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
- 海思开发博客
- 14.数据类型的本质含义
- 文章标题
- 在Linux中让echo命令显示带颜色的字
- 求内存利用情况
- Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'解决
- 博客专栏第一篇文章——我眼里的DBA
- 老公最近吃某种药,吃完了就一直排气。这天,他们一行人去工地检查,排着队爬一个高塔的时候,老公没忍住排了一长串气,紧跟在他后面的人脸都绿了,忍不住说:“你这是要起飞呀!”
- python基础学习
- oracle user_users,dba_users,all_users
- 当在ecplise导入一个工程,tomcat识别不了导致无法add的时候可以这样做
- 时间按格式转字符串
- 排序、查找
- tableView下拉放大头部视图