I performed an unattended upgrade to MySQL 5.6.16 and now MySQL fails to start.
The mysql service is listed as “down” in the Service Status page inside WHM and I’m receiving regular emails from the service monitor indicating that mysql has failed and that a restart is being attempted automagically.
Creating new accounts is problematic and presents mysql related errors and CPHulk isn’t working without mysql either.
To make matters worse I can’t connect via ssh and receive a “connection refused” message when attempting. Port 22 is open in the firewall which is managed by the csf v6.47 plugin and my ip address whitelisted, my IP is also allowed in the host access control list and is set up as a recognized ip for root.
I have tried a few simple things to resolve as follows:
- Restart MySQL Service
When restarting the MySQL service from inside WHM it hangs on the Restarting Service modal screen for a couple of mins before displaying the following:
Waiting for mysql to restart......finished.
mysql has failed, please contact the sysadmin (result was "mysql is not running").
- Rebooting the server. Service still fails to start
- Performed the unattended MySQL upgrade again. No errors are reported however I haven’t trawled through the 5800 lines of results produced during this process and wouldn’t know what to look for.
The server is a newly provisioned VPS with two accounts setup but no sites currently hosted and no databases inside either of the accounts. I uploaded some test files to one of the accounts and they’re accessible through the browser and ftp without any problems. The Cpanels for both accounts are also functioning correctly except for the MySQL functions.
WHM version is 11.42.0 (build 23) running on Cloudlinux 6.5 x86_64 xenpv
Thanks in advance for any help or adive
The mysql service is listed as “down” in the Service Status page inside WHM and I’m receiving regular emails from the service monitor indicating that mysql has failed and that a restart is being attempted automagically.
Creating new accounts is problematic and presents mysql related errors and CPHulk isn’t working without mysql either.
To make matters worse I can’t connect via ssh and receive a “connection refused” message when attempting. Port 22 is open in the firewall which is managed by the csf v6.47 plugin and my ip address whitelisted, my IP is also allowed in the host access control list and is set up as a recognized ip for root.
I have tried a few simple things to resolve as follows:
- Restart MySQL Service
When restarting the MySQL service from inside WHM it hangs on the Restarting Service modal screen for a couple of mins before displaying the following:
Waiting for mysql to restart......finished.
mysql has failed, please contact the sysadmin (result was "mysql is not running").
- Rebooting the server. Service still fails to start
- Performed the unattended MySQL upgrade again. No errors are reported however I haven’t trawled through the 5800 lines of results produced during this process and wouldn’t know what to look for.
The server is a newly provisioned VPS with two accounts setup but no sites currently hosted and no databases inside either of the accounts. I uploaded some test files to one of the accounts and they’re accessible through the browser and ftp without any problems. The Cpanels for both accounts are also functioning correctly except for the MySQL functions.
WHM version is 11.42.0 (build 23) running on Cloudlinux 6.5 x86_64 xenpv
Thanks in advance for any help or adive