Mysql Service Start fail

[LFofficial]

Hello,

my website was brute force attack and one of my site was attacked with spam, idk how but the one that got spammed , has a database size of 13GB now,
for reason my sql service is not startigng anymore.

Waiting for “mysql” to start ………Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. …Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. …failed.

Cpanel::Exception::Services::StartError Service Status
undefined status from Cpanel::ServiceManager::Services::Mysql

Service Error
(XID vcg2yt) The “mysql” service failed to start.

Startup Log
Dec 20 12:40:15 185-207-207-160.cprapid.com systemd[1]: Failed to start MySQL Server.
Dec 20 12:40:15 185-207-207-160.cprapid.com systemd[1]: Unit mysqld.service entered failed state.
Dec 20 12:40:15 185-207-207-160.cprapid.com systemd[1]: mysqld.service failed.

Log Messages
2022-12-20T17:40:15.587713Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2022-12-20T17:40:13.815959Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2022-12-20T17:40:12.136991Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2022-12-20T17:39:29.147305Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Dec 20 12:40:15 185-207-207-160 mysqld: Initialization of mysqld failed: 0

mysql has failed. Contact your system administrator if the service does not automagically recover.

 

[cPRex]

Hey there! Do you see anything helpful in the MySQL error log? That should show if there is a bad variable or configuration file keeping the service from starting. You can run this command to get the location of your MySQL error log file:

grep log-error /etc/my.cnf

 

[LFofficial]

Hey there! Do you see anything helpful in the MySQL error log? That should show if there is a bad variable or configuration file keeping the service from starting. You can run this command to get the location of your MySQL error log file:

grep log-error /etc/my.cnf

Hello thank you,
I am running root yet it shows i dont have permisison,

 

[cPRex]

That could be a clue. What does this command show:

ls -lah /etc/my.cnf

Ideally, we'd like to see 644 permissions on that file and root ownership, such as this example:

-rw-r--r-- 1 root root 1.2K Oct 11 05:35 /etc/my.cnf