Problem

This issue is typically the result of a recent MySQL upgrade. If you are seeing these errors, they are likely coming to you as a cronjob error in your e-mail. The error most often states:

/etc/cron.hourly/modsecparse.pl: DBI connect(’modsec:localhost’,'modsec’,…) failed: Access denied for user ‘modsec’@'localhost’ (using password: YES) at /etc/cron.hourly/modsecparse.pl line 19 Unable to connect to mysql database at /etc/cron.hourly/modsecparse.pl line 19.

Resolution

To fix this issue, open up an SSH session and use the following commands:

Take a look at the modsec user’s password, then flip over to CPanel’s WHM. Click on phpMyAdmin and then in phpMyAdmin click Privileges > M > and edit the user Modsec. Change the password to whatever the password was in the aforementioned modsecparse.pl.