MySQL 启动 登录报错Job for mysqld.service failed because the control process exited with error code. See

启动数据库报错

Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.报错的情况

进入数据库报错

ERROR 2002 (HY000): Can't connect to local MySQL server through

socket '/var/lib/mysql/mysql.sock' (2)

问题出现的过程

我在通过（percona-xtrabackup）这款MySQL开源工具 做备份恢复 时候 遇见这样的问题

当时把整个数据库删掉 /var/lib/mysql/  下的所有文件删掉

然后通过以下命令恢复数据库

回滚事务日志
innobackupex --apply-log /2024-01-02_00-12-37  /后边是备份的地点
 
恢复数据库
innobackupex --copy-back /2024-01-02_00-12-37        

在启动数据库的时候出现 报错

Job for mysqld.service failed because the control process exited 
with error code. See "systemctl status mysqld.service" and 
"journalctl -xe" for details.

进入数据库时报错

1. ERROR 2002 (HY000): Can't connect to local MySQL server through 
2. socket '/var/lib/mysql/mysql.sock' (2)
3.

解决过程

当我们删除 /var/log/mysql 下所有的文件

我们以root身份恢复数据库时候 属主和属组都是root

我们需要将它更改为 mysql

chown -R mysql.mysql /var/lib/mysql
 
systemctl restart mysqld