Mysql Service Start fail

LFofficial

• December 20, 2022 11:41

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. [QUOTE] 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 Jurassic Moderator

  • December 20, 2022 17:39

  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
  

  0
• 

  LFofficial

  • December 20, 2022 17:42

  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,

  0
• 

  cPRex Jurassic Moderator

  • December 20, 2022 19:02

  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

  0

Please sign in to leave a comment.