关于linux无法登陆mysql，报错Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

登陆mysql的时候报下面这个错误

[root@localhost ~]# mysql -hlocalhost -uroot -p123456
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' (111)

查看mysql的状态显示：

[root@localhost ~]# systemctl status mysqld
mysqld.service - SYSV: MySQL database server.
Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)

 

网上解决方案：

[root@localhost run]# sudo mkdir -p /var/run/mysqld
[root@localhost run]# sudo chown mysql.mysql mysqld
[root@localhost run]# sudo systemctl start mysqld

 

其他解决方案：

https://www.jianshu.com/p/422b2cc79110

https://blog.csdn.net/l1028386804/article/details/46048485