mysql命令启动报错:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
修改my.cnf文件:
在/etc/my.cnf文件中添加如下内容,并重启mysqls服务,
即可解决mysql,mysqldump,mysqladmin的“Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'”问题:
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#添加配置
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql]
socket=/var/lib/mysql/mysql.sock
[client]
socket=/var/lib/mysql/mysql.sock
[mysqldump]
socket=/var/lib/mysql/mysql.sock
[mysqladmin]
socket=/var/lib/mysql/mysql.sock