Issue :
Getting below error for RoundCube
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server- administrator.
There are a few things to be checked while working with this problem.
The database is repaired if the entire table exists. To repair a DB follow this command
mysqlcheck -r roundcube
The RoundCube can be rebuilt with the command line if the database or tables is missing. The command used to rebuild RoundCube is:
FOR BACKING UP THE DATABASE USE THE FOLLOWING
mysqldump roundcube > roundcube.sql
FOR DROPPING THE DATABASE:
The command below has to run in MySQL prompt
DROP DATABASE roundcube;
FOR REBUILDING PURPOSE
/usr/local/cpanel/bin/update-roundcube –force
TO RESTORE:
mysql roundcube < roundcube.sql