mysql登陆error2002_MySQL登录报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/t...

[root@pisphkdcbsql01 mysql3307]# /opt/mysql3307/bin/mysql -upisp -ppisp@123mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR2002 (HY000): Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2)

解决办法

[root@pisphkdcbsql01 tmp]# ln -s /opt/mysql3307new/mysql-3307.sock mysql.sock

[root@pisphkdcbsql01 tmp]# ll -thr

total 4.9M

-rw------- 1 root  root   783 May 26  2017 yum_save_tx-2017-05-26-09-23etoC8C.yumtx

-rw-r--r-- 1 root  root    42 Jan  8  2018 network.bak

-rw------- 1 root  root   248 Jan  9  2018 yum_save_tx-2018-01-09-11-33Y0mCc_.yumtx

-rw------- 1 root  root  1.7K Jan  9  2018 yum_save_tx-2018-01-09-11-48cbmJd8.yumtx

-rw------- 1 root  root   513 Jan  9  2018 yum_save_tx-2018-01-09-12-047IB4sD.yumtx

-rw-r--r-- 1 root  root   521 Jan  9  2018 centos6_haikou_nanshu.repo