mysql登录的报错Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

重启后，继续报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

[root@192 ~]# mysqld
2020-04-27T02:54:10.448733Z 0 [System] [MY-010116] [Server] /app/database/mysql-8.0.11-linux-glibc2.12-x86_64/bin/mysqld (mysqld 8.0.11) starting as process 2296
2020-04-27T02:54:10.815201Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-27T02:54:10.816733Z 0 [ERROR] [MY-010270] [Server] Can't start server : Bind on unix socket: Address already in use
2020-04-27T02:54:10.816749Z 0 [ERROR] [MY-010258] [Server] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
2020-04-27T02:54:10.816761Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-04-27T02:54:12.606929Z 0 [System] [MY-010910] [Server] /app/database/mysql-8.0.11-linux-glibc2.12-x86_64/bin/mysqld: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.
[root@192 ~]# rm -rf /tmp/mysql.sock
[root@192 ~]# systemctl restart mysqld.service 
[root@192 ~]# mysqld
2020-04-27T02:55:13.040339Z 0 [System] [MY-010116] [Server] /app/database/mysql-8.0.11-linux-glibc2.12-x86_64/bin/mysqld (mysqld 8.0.11) starting as process 2394
2020-04-27T02:55:14.129116Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-27T02:55:14.199958Z 0 [System] [MY-010931] [Server] /app/database/mysql-8.0.11-linux-glibc2.12-x86_64/bin/mysqld: ready for connections. Version: '8.0.11'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server - GPL.

解决方法

1.首先删除报错的文件/tmp/mysql.sock，删除之后再次连接。

2.再次尝试mysql或者mysqld进入数据库，此时我的数据库现实如上报错。Do you already have another mysqld server running on socket: /tmp/mysql.sock ?我立刻关闭mysql程序，再次删除这个文件，删除以后，重启mysql窗口卡住，另一个窗口正常工作。