Issue with mysqld starting service today onwards

[Anil kumar]

please help , It was working fine but today onwards following issue .


systemctl status mysqld.service
● mysqld.service - MySQL 8.0 database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Sat 2021-11-20 18:07:06 IST; 16s ago
Process: 6350 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=3)
Process: 6305 ExecStart=/usr/libexec/mysqld --basedir=/usr (code=exited, status=1/FAILURE)
Process: 6268 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (code=exited, status=0/SUCCESS)
Process: 6242 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
Main PID: 6305 (code=exited, status=1/FAILURE)
Status: "Server startup in progress"

Nov 20 18:04:24 localhost.localdomain systemd[1]: Starting MySQL 8.0 database server...
Nov 20 18:04:24 localhost.localdomain mysql-check-socket[6242]: Socket file /var/lib/mysql/mysql.sock exists.
Nov 20 18:04:24 localhost.localdomain mysql-check-socket[6242]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed autom>
Nov 20 18:06:05 localhost.localdomain systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
Nov 20 18:07:06 localhost.localdomain systemd[1]: mysqld.service: Control process exited, code=exited status=3
Nov 20 18:07:06 localhost.localdomain systemd[1]: mysqld.service: Failed with result 'exit-code'.
Nov 20 18:07:06 localhost.localdomain systemd[1]: Failed to start MySQL 8.0 database server.
[root@localhost ~]#