debian9 mysql (maridb)启动失败 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '

问题

以前好好的假mysql，也没咋用过，今天写作要用了， 突然不能用了，wtf，

(base) zh@deb:~$ mysql -u zh -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

从网上找了个办法，但是，然并卵

root@deb:/home/zh# mysql -h 127.0.0.1 -u root -p
Enter password: 
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")

解决

来咱看看mysql服务启动没
(base) zh@deb:~$ sudo service mysql status
[sudo] password for zh: 
● mariadb.service - MariaDB 10.1.41 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Sat 2019-10-05 16:05:52 CST; 1h 19min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 797 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 711 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, 
  Process: 593 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 557 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 797 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"
      CPU: 296ms

Oct 05 16:05:48 deb systemd[1]: Starting MariaDB 10.1.41 database server...
Oct 05 16:05:49 deb mysqld[797]: 2019-10-05 16:05:49 140141365412992 [Note] /usr/sbin/mysqld (mysqld 10.1.41-MariaDB-0+deb9u1) starting as process 797 ...
Oct 05 16:05:52 deb systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Oct 05 16:05:52 deb systemd[1]: Failed to start MariaDB 10.1.41 database server.
Oct 05 16:05:52 deb systemd[1]: mariadb.service: Unit entered failed state.
Oct 05 16:05:52 deb systemd[1]: mariadb.service: Failed with result 'exit-code'.

竟然没，
手动搞他

(base) zh@deb:~$ sudo service mysql start
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

竟然打不开，
只能百度了， 打开出错的日志看看

(base) zh@deb:~$ cd /var/log/
(base) zh@deb:/var/log$ ls
alternatives.log    aptitude.1.gz  btmp          daemon.log.2.gz  dpkg.log    fontconfig.log  kern.log.2.gz  messages.1     syslog.1     syslog.5.gz          user.log       vmware-installer  Xorg.0.log
alternatives.log.1  auth.log       btmp.1        debug            dpkg.log.1  installer       lastlog        messages.2.gz  syslog.2.gz  syslog.6.gz          user.log.1     vnetlib           Xorg.0.log.old
apt                 auth.log.1     daemon.log    debug.1          exim4       kern.log        lightdm        mysql          syslog.3.gz  syslog.7.gz          user.log.2.gz  wpslog            Xorg.1.log
aptitude            auth.log.2.gz  daemon.log.1  debug.2.gz       faillog     kern.log.1      messages       syslog         syslog.4.gz  unattended-upgrades  vmware         wtmp              Xorg.1.log.old
(base) zh@deb:/var/log$ cd mysql
bash: cd: mysql: Permission denied
(base) zh@deb:/var/log$ sudo cd mysql
sudo: cd: command not found
(base) zh@deb:/var/log$ su
Password: 
root@deb:/var/log# 
root@deb:/var/log# 
root@deb:/var/log# cd mysql
root@deb:/var/log/mysql# ls
error.log  error.log.1.gz  error.log.2.gz  error.log.3.gz  error.log.4.gz  error.log.5.gz  error.log.6.gz  error.log.7.gz
root@deb:/var/log/mysql# vim error.log

他日志里，最新的是（拷不出来）

然后就问度娘，它说这个倒数第二行的文件要删除。

解决

root@deb:/lib# cd /var/lib
root@deb:/var/lib# ls
alsa	  aspell     containerd  dictionaries-common  docker-engine   exim4	   git		    libreoffice  man-db  NetworkManager  pam	   sgml-base  systemd  upower	 vmware  xml-core
apt	  blueman    dbus	 dkms		      dpkg	      gconf	   initramfs-tools  lightdm	 misc	 os-prober	 polkit-1  sudo       ucf      usbutils  xfonts
aptitude  bluetooth  dhcp	 docker		      emacsen-common  ghostscript  ispell	    logrotate	 mysql	 PackageKit	 python    synaptic   udisks2  vim	 xkb
root@deb:/var/lib# cd mysql
root@deb:/var/lib/mysql# ls
aria_log.00000001  aria_log_control  debian-10.1.flag  ibdata1	ib_logfile0  ib_logfile1  multi-master.info  mysql  performance_schema	tc.log
root@deb:/var/lib/mysql# ls
aria_log.00000001  aria_log_control  debian-10.1.flag  ibdata1	ib_logfile0  ib_logfile1  multi-master.info  mysql  performance_schema	tc.log
root@deb:/var/lib/mysql# rm -f tc.log
(base) zh@deb:/opt$ sudo service mysql start 
(base) zh@deb:/opt$ mysql -u zh -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.41-MariaDB-0+deb9u1 Debian 9.9

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
nice

---

然后再一次开价的发现，又开不开了，服务又打不开。。。。。。。。。。。。。。。。。。wtf

然后看/var/log 下的error.log, 发现说啥空间不够了，然后在var目录下du -sh * 发现lib竟然8个多G，这还了得，再进一步查看，发现docker的容器镜像啥的都在这，这个我安系统的时候选的分盘，结果var现在就满了。。。。。。。。然后就把docker放在了别的目录然后建立了啥连接，接着docker就不能用了，但是ls还能出来，

就只能改配置了，

vim /etc/docker/daemon.json

位置也换了，空间也腾出来了，mysql也能用了，不过我还是想说狗屁docker就不自己初始配置成别的地方吗，差评