版本:8.X
前言
今天清理系统日志,想着也没什么重要的东西直接命令[ rm -rf ]完事,结果导致mysql启动不起来,花了一点时间找原因特此记录
问题
mysql启动报错,输入命令打印提示:
mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2024-05-09 14:59:24 CST; 5s ago
Process: 4574 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Process: 4582 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Main PID: 4582 (code=exited, status=1/FAILURE)
Status: "Server shutdown complete"
Error: 2 (没有那个文件或目录)
CPU: 300ms
原因
幸运的是今天操作少,直接定位到是mysql日志文件被删除,去my.cnf查找一番有哪些文件和目录直接补上,这里我只有一个文件,路径是:/var/log/mysql/error.log
解决问题
输入命令:
cd /var/log
mkdir mysql
touch mysql/error.log
systemctl start mysql
出现错误
mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2024-05-09 15:15:58 CST; 5s ago
Process: 4715 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Process: 4723 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Main PID: 4723 (code=exited, status=1/FAILURE)
Status: "Server shutdown complete"
Error: 13 (权限不够)
CPU: 295ms
这个就简单了直接干掉
chmod 777 mysql/error.log
问题解决