mysql client mysqld_mysql加上[client]中/tmp/mysqld.sock参数才能登录？

今天安装mysql5.7，分别在centos7与redhat6.5上安装my.cnf文件配置如下：[mysql]default_character_set=utf8socket=/home/istorm/mysql/mysqld.sock [mysqld]user=istormport=33...

今天安装mysql5.7，分别在centos7与redhat6.5上安装

my.cnf文件配置如下：

[mysql]

default_character_set=utf8

socket=/home/istorm/mysql/mysqld.sock

[mysqld]

user=istorm

port=3306

max_connections=500

character_set_server=utf8

lower_case_table_names=1

basedir=/home/istorm/mysql

datadir=/home/istorm/mysql/data

log-error=/home/istorm/mysql/logs/mysql.err

language=/home/istorm/mysql/share/english

pid-file=/home/istorm/mysql/mysqld.pid

socket=/home/istorm/mysql/mysqld.sock

在Centos7中，安装启动过程顺利，但是在redhat6.5中，必须要加上

[client]

socket=/home/istorm/mysql/mysqld.sock

加上之后，mysql -u root -p即可正常登录，为什么redhat6.5上要加上这个client参数才能正常登录？否则报错如下：

mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/istorm/mysql/mysqld.sock' (2)

不加client，使用mysql -h 127.0.0.1 -u root -p才能登录

展开