MySQL problem after 11.36 update

[Toufick]

Last night, cpanel was autoupdated to 11.36

Since, each time I restart my VPS, MySQL is not restarted and this message is displayed on my website

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

So each time my VPS is rebooted, I have to use this command to start MySQL

/scripts/restartsrv_mysql

Ho to remedy to this ?

Many thanks in advance

 

[blahnana]

I'm getting the same behaviour with several cPanel installations (all were first installed around 4-6 months ago). All similar circumstances, up to date in the cPanel RELEASE strain. Rebooting them causes them to boot perfectly, but MySQL isn't running after init. 'service mysql start' works perfectly. I've noticed that mysql isn't listed in 'chkconfig --list', but I don't remember noticing whether MySQL was there previously.

I checked the service list in WHM, MySQL is enabled but not monitored.

 

[Toufick]

Hi

Here is the solution

Run this command
# chkconfig --list mysql
If you get this message
service mysql supports chkconfig, but is not referenced in any runlevel (run 'chkconfig --add mysql')
Run
# chkconfig --add mysql
Then
# chkconfig --levels 345 mysql on


Solution given by Mark from cpanel support