mysql连接时报错:Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock'
修改 /etc/my.cnf下的文件配置:
[mysqld]
port = 3306
basedir = /var/lib/mysql
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=root
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/var/lib/mysql/mysql.sock
我的原因时没有:
[client]
socket=/var/lib/mysql/mysql.sock
添加上就可以了