1.MySQL沒加入開機自啟動泪勒,每次啟動虛擬機的時候MySQL沒有啟動,手動啟動:systemctl start mysqld.service
然后就報錯:
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
查看日志如下:
[root@laiye log]# tail -f /var/log/mysqld.log
2020-05-17T05:47:33.804574Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.30' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2020-05-17T05:50:07.976326Z 2 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2020-05-17T05:51:02.259336Z 3 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2020-05-17T05:51:58.024437Z 4 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2020-05-17T05:55:57.869202Z 5 [Warning] Plugin validate_password reported: 'Effective value of validate_password_length is changed. New value is 4'
2020-05-17T06:23:02.637971Z 7 [Warning] IP address '192.168.171.1' could not be resolved: Name or service not known
2020-05-17T06:23:02.640461Z 7 [Note] Access denied for user 'root'@'192.168.171.1' (using password: YES)
2020-05-17T14:45:05.966082Z 9 [Note] Aborted connection 9 to db: 'unconnected' user: 'uibot' host: '192.168.171.1' (Got timeout reading communication packets)
2020-05-17T14:45:05.966631Z 8 [Note] Aborted connection 8 to db: 'uibot_commander' user: 'uibot' host: '192.168.171.1' (Got timeout reading communication packets)
查看MySQL服務狀態(tài):
[root@laiye log]# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: start-limit) since 一 2020-05-11 10:41:05 CST; 6min ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 2370 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Process: 2343 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
5月 11 10:41:05 laiye systemd[1]: Failed to start MySQL Server.
5月 11 10:41:05 laiye systemd[1]: Unit mysqld.service entered failed state.
5月 11 10:41:05 laiye systemd[1]: mysqld.service failed.
5月 11 10:41:05 laiye systemd[1]: mysqld.service holdoff time over, scheduling restart.
5月 11 10:41:05 laiye systemd[1]: Stopped MySQL Server.
5月 11 10:41:05 laiye systemd[1]: start request repeated too quickly for mysqld.service
5月 11 10:41:05 laiye systemd[1]: Failed to start MySQL Server.
5月 11 10:41:05 laiye systemd[1]: Unit mysqld.service entered failed state.
5月 11 10:41:05 laiye systemd[1]: mysqld.service failed.
反正沒看出什么也有用的信息,繼續(xù)百度找答案···
搞毛線, 太多了,直接重裝一下算了
1游两,先卸載
yum remove mysql
2,查看yum是否安裝過mysql
yum list installed mysql*
yum remove 對應的包
rm -rf /var/lib/mysql
rm /etc/my.cnf
3漩绵,rpm查看安裝
rpm -qa | grep -i mysql
rpm -e 對應找到的包
cd /var/lib/
rm -rf mysql/
4贱案,清除余項
whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/local/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
刪除上面的文件夾
rm -rf /usr/bin/mysql
5,刪除配置
rm –rf /usr/my.cnf
rm -rf /root/.mysql_sercret
6止吐,剩余配置檢查
chkconfig --list | grep -i mysql
chkconfig --del mysqld