登录mysql报错:Can't connect to local

参考https://www.cnblogs.com/Lam7/p/6090975.html

错误详情：
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
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 '/var/lib/mysql/mysql.sock' (2)
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 '/var/lib/mysql/mysql.sock' (2)
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 '/var/lib/mysql/mysql.sock' (2)

报错原因是：
mysql的配置文件my.cnf里配置的socket文件是/var/lib/mysql/mysql.sock，但是我的服务器上不存在/var/lib/mysql/mysql.sock文件：

服务器上存在的socket文件是/var/run/mysqld/mysqld.sock。

我的解决办法是建立一个软链接/var/lib/mysql/mysql.sock指向/var/run/mysqld/mysqld.sock：
ln -s /var/run/mysqld/mysql.sock /var/lib/mysql/mysql.sock
这样就可以访问成功了。