MySQL断电后报错处理

前言

问题保留，如果有大佬会可以留言教我一下！

因为做的cacti没有做完，回家的时候就将电脑从休眠状态起不来。于是我就断电重启。自此mysql就不正常了，一直出现报错。因为之前部署zabbix出现过同样的问题，当时直接重装了系统。这次希望能用心解决一下，积累自己的排错经验。

1.查看端口状态，看是否开启：

[root@server1 mariadb]# netstat -tnlp
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      45129/mysqld        

2.服务状态running：

[root@server1 mariadb]# systemctl status mariadb
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
   Active: active (running) since Thu 2020-07-09 09:39:24 CST; 10min ago
  Process: 32031 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 31999 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 32030 (mysqld_safe)
    Tasks: 32
   CGroup: /system.slice/mariadb.service
           ├─32030 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           ├─46481 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql ...
           └─46641 addr2line -C -f -e /usr/libexec/mysqld

Jul 09 09:39:21 server1 systemd[1]: Starting MariaDB database server...
Jul 09 09:39:21 server1 mariadb-prepare-db-dir[31999]: Database MariaDB is prob...
Jul 09 09:39:22 server1 mysqld_safe[32030]: 200709 09:39:22 mysqld_safe Loggin....
Jul 09 09:39:22 server1 mysqld_safe[32030]: 200709 09:39:22 mysqld_safe Starti...l
Jul 09 09:39:24 server1 systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.

看起来并没有异常。
3.用root用户登录mysql

[root@server1 mariadb]# mysql -uroot -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g