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

[Leonidas Savvides]

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

 

[Leonidas Savvides]

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

 

[jalmatari]

I have the same problem, Just it happened at night suddenly!!

 

[Leonidas Savvides]

GO TO RESTART MYSQL AND GETTING>>> // Well????

• Home »
  Restart Services »
  SQL Server (MySQL)
  Documentation

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.

 

[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

 

[nitro535]

Same here!

 

[Leonidas Savvides]

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
"

 

[wintech2003]

Hello,

Please check Known Issues Status Page 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

 

[Leonidas Savvides]

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?

 

[cPanelLauren]

I'd suggest reading the following thread: Known Issues Status Page

 

[Leonidas Savvides]

#5
godzilla

this thread above is a little different in the cmd to run --- are two commands in #5 above????

 

[Leonidas Savvides]

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...?

 

[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.

 

[cPanelLauren]

The linked thread is the official response from cPanel and the only one recommended to be utilizing for this issue.

 

[Leonidas Savvides]

My Domains - DNS Management
Host Names

SOLVED BY CHANGING ALSO
HOST NAMES TO TARGET IP