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

Leonidas Savvides

Active Member
May 10, 2016
42
4
8
Cyprus
cPanel Access Level
Root Administrator
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
 

Attachments

Leonidas Savvides

Active Member
May 10, 2016
42
4
8
Cyprus
cPanel Access Level
Root Administrator
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
 
Last edited:

Leonidas Savvides

Active Member
May 10, 2016
42
4
8
Cyprus
cPanel Access Level
Root Administrator
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.
 
Last edited:

Leonidas Savvides

Active Member
May 10, 2016
42
4
8
Cyprus
cPanel Access Level
Root Administrator
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
"
 

Leonidas Savvides

Active Member
May 10, 2016
42
4
8
Cyprus
cPanel Access Level
Root Administrator
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?
 

jakecollingwood

Registered
Nov 6, 2019
1
0
1
United Kingdom
cPanel Access Level
Root Administrator
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.