解决Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误 - 似水流年 - CSDN博客

安宇雨 - 随手采集
2018-10-23 19:18:11
随手采集
0000-未整理-等待研究

刚安装完mysql，进行运行测试，报Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’错误，

[root@localhost mysql]# /usr/local/mysql/bin/mysqld_safe
131206 22:42:51 mysqld_safe Logging to ‘/var/log/mysqld.log’.
131206 22:42:51 mysqld_safe Starting mysqld daemon with databases from /data/mysql/data
131206 22:42:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[root@localhost mysql]# /usr/local/mysql/bin/mysql
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

检查一下mysql的运行状态
[root@localhost mysql]# ps -ef | grep mysql
root 32092 2108 0 22:43 pts/0 00:00:00 grep mysql

查看/tmp文件夹的确没有mysql.sock文件，

通过find命令查找

[root@localhost /]# find / -name mysql.sock
/var/lib/mysql/mysql.sock

原来安装到/var/lib/mysql/mysql.sock这个位置啦，我们需要修改my.cnf文件

[root@localhost /]# vi /etc/my.cnf

[client]
character-set-server = utf8
port = 3306
socket = /var/lib/mysql/mysql.sock
……

保存之后即出，重新启动mysql。

转载：http://www.chenruixuan.com/archives/517.html

Original url: Access
Created at: 2018-10-23 19:18:11
Category: default
Tags: none

未标明原创文章均为采集，版权归作者所有，转载无需和我联系，请注明原出处，南摩阿彌陀佛，知识，不只知道，要得到