Skip to main content

My old centos6 server has MySQL down in all sites/domains use mysql

lse webmaster
My old centos6 server has MySQL down in all sites: anotherMyDomain.com Cpanel MySQL" Databases The MySQL server is currently offline. Error while connecting to MySQL: (XID hckdua) The system failed to connect to the "MySQL" database "mysql" because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) Error while connecting to MySQL: (XID hckdua) The system failed to connect to the "MySQL" database "mysql" because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, line 1. what is this about??? what to do to fix MySQL error???? see attachment

Comments

14 comments

Date Votes
  • lse webmaster
    also WHM needed update --- yet do... CENTOS 6.10 virtuozzo [s104-238-xxx-xxx] v82.0.17 Load Averages: 0.01 0.03 0.00 WHM (Web Host Manager) News Change Log Log Out (root) Filesystem quotas are currently disabled. Click to enable.Version "84.0.7" is available. Update Now
    0
  • jalmatari
    I have the same problem, Just it happened at night suddenly!!
    0
  • lse webmaster
    GO TO RESTART MYSQL AND GETTING>>> // Well????
    • Home " Restart Services " SQL Server (MySQL) Documentation
    https://104.238.97.64:2087/cPanel_magic_revision_1492379578/themes/x/icons/sql_server_mysql.png
    Restarting MySQL Server     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 Service Error (XID vk4e2j) The "mysql" service failed to start. Startup Log Starting MariaDB.191106 11:06:12 mysqld_safe Logging to '/var/lib/mysql/s104-238-XXX-XXX.secureserver.net.err'. 191106 11:06:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /etc/init.d/mysql: line 264: kill: (3885) - No such process ERROR! mysql has failed. Contact your system administrator if the service does not automagically recover.
    0
  • godzilla
    It's a known issue with MariaDB. Just run yum downgrade MariaDB-* -y whmapi1 update_updateconf RPMUP=manual UPDATES=manual
    and wait for the fix
    0
  • nitro535
    Same here!
    0
  • lse webmaster
    THE HOSTING SUPPORT SAID: // CAN you provide me any hint/help on this...? " my team and they said that there is a connectivity issue between the mysql server and the server socket layer ( mysql.sock file ). This is something which need to be checked with cpanel forums or server admin. Thanks and Regards, HOSTING SUPPORT "
    0
  • George_Fusioned
    Hello, Please check for more information. A quick fix is to temporarily downgrade MariaDB to it's previous version by running: yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
    0
  • lse webmaster
    In other words you mean MariaDB updated auto So will downgrade to version just before 05 Nov...? By Restarting MySQL from WHM this may update MariaDB...? What else do MariaDB to update automatically?
    0
  • cPanelLauren
    I'd suggest reading the following thread:
    0
  • lse webmaster
    #5 godzilla this thread above is a little different in the cmd to run --- are two commands in #5 above????
    0
  • lse webmaster
    By Restarting MySQL from WHM this may update MariaDB...? What else do MariaDB to update automatically?

    IF downgrade MariaDB... Do I have to set updates to manual???
    • Home "
    • Server Configuration "
    • Terminal
    Can update using WHM Terminal in the browser, or you recommend ssh normally from Linux CLI/CMD...?
    0
  • jakecollingwood
    My old centos6 server has MySQL down in all sites: anotherMyDomain.com Cpanel MySQL" Databases The MySQL server is currently offline. Error while connecting to MySQL: (XID hckdua) The system failed to connect to the "MySQL" database "mysql" because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) Error while connecting to MySQL: (XID hckdua) The system failed to connect to the "MySQL" database "mysql" because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, line 1. what is this about??? what to do to fix MySQL error???? see attachment

    Have you had any luck finding a solution to this? The same happened to me early this morning. Approx 2:27am London time. Interestingly an unknown unauthorized person logged in to a wordpress site of mine only 15 mins before that.
    0
  • cPanelLauren
    The linked thread is the official response from cPanel and the only one recommended to be utilizing for this issue.
    0
  • lse webmaster
    My Domains - DNS Management Host Names SOLVED BY CHANGING ALSO HOST NAMES TO TARGET IP
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post