Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)

数据库启动不了可能是你的硬盘没空间啦！！
启动数据库报错：

root@dream2:/root # mysql  
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
root@dream2:/root # systemctl start mysql
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
root@dream2:/root # systemctl status mysql.service
● mysql.service - MySQL Community Server
   Loaded: loaded (/etc/systemd/system/mysql.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2021-01-15 00:52:08 CST; 36s ago
  Process: 44242 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Jan 15 00:52:06 dream2 systemd[1]: Starting MySQL Community Server...
Jan 15 00:52:08 dream2 mysql[44242]: Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/dream2.pid).
Jan 15 00:52:08 dream2 systemd[1]: mysql.service: Control process exited, code=exited status=1
Jan 15 00:52:08 dream2 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 15 00:52:08 dream2 systemd[1]: Failed to start MySQL Community Server.

按照提示输入如下命令看具体情况：

root@dream2:/root # journalctl -xe

小知识：journalctl是查询系统日志的工具

输出如下：

-- Unit mysql.service has begun starting up.
Jan 15 00:52:08 dream2 mysql[44242]: Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/dream2.pid).
Jan 15 00:52:08 dream2 systemd[1]: mysql.service: Control process exited, code=exited status=1
Jan 15 00:52:08 dream2 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 15 00:52:08 dream2 systemd[1]: Failed to start MySQL Community Server.

复制报错语句，开始百度，开始试了一波方法还是不行，然后发现有老哥说可能是硬盘没空间了，赶紧去看了看：

root@dream2:/root # df -h
Filesystem      Size  Used Avail Use% Mounted on
devtmpfs        395M     0  395M   0% /dev
tmpfs           410M     0  410M   0% /dev/shm
tmpfs           410M   47M  363M  12% /run
tmpfs           410M     0  410M   0% /sys/fs/cgroup
/dev/vda1        32G   31G     0 100% /
overlay          32G   31G     0 100% /var/lib/docker/overlay2/665796a97544627d82e8f9d1111125bd2ab55194b3fd9ff4253d6fb598228749/merged
shm              64M     0   64M   0% /var/lib/docker/containers/848b307a154c724299997b71f45a5746ce1b1035794c7d27f2e1234b3a4a98ab/mounts/shm
overlay          32G   31G     0 100% /var/lib/docker/overlay2/b769ca4650dfaef590a9f97013f5f8ad83c7f8bd2aaa4d3c5ce8fec250af7244/merged
shm              64M     0   64M   0% /var/lib/docker/containers/e6eaa7882c48f3256262afda82db10ef9e5a719735ca0e98dfdd5a8af56ceabd/mounts/shm
tmpfs            82M     0   82M   0% /run/user/0

果然，然后删了一波之前的docker镜像，重新启动mysql，完事儿。

---