ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘(）

 踩坑指南

在etc/my.cnf配置文件中完善信息

 

[mysqld]

bind-address=0.0.0.0

port=3306

user=mysql

basedir=/usr/local/mysql

datadir=/data/mysql

socket=/tmp/mysql.sock

log-error=    

pid-file=/data/mysql/mysql.pid

#character config

character_set_server=utf8mb4

symbolic-links=0

explicit_defaults_for_timestamp=true

#在配置文件中加入以下两个！！！就好了

[client]
socket=/tmp/mysql.sock

[mysql]
socket=/tmp/mysql.sock