最近使用二进制安装的方式安装了一台MySQL5.7,发现使用之前(源码安装)的连接方式报错。
[root@oracle_db ~]# mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
我的配置文件(/etc/my.cnf):
[mysqld]
log_bin = server-130-bin
gtid_mode = ON
log_slave_updates = 1
enforce_gtid_consistency = ON
binlog_format=row
#read_only=1
relay_log_purge=0
basedir = /usr/local/mysql/
#datadir = /home/mysql/data/
datadir = /usr/local/mysql/data/
port = 3306
server_id = 130
socket = /usr/local/mysql/mysql.sock
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]</