Cpanel

now browsing by category

Cpanel stuff

 

How to fix horde DB connect failed error with cpanel

The easiest way to see whats wrong is see if horde is able to connect to mysql

cat /usr/local/cpanel/base/horde/config/conf.php | grep conf | grep sql

This should show what horde is using for mysql user and pass

Then run

mysql -h <host if remote> or localhost -u horde -p<password>

If you get an error of some kind, then you need log into mysql and run the following below

GRANT ALL ON *.* TO ‘horde’@’whatever host the error said or use localhost’ identified by ‘whatever password it said above’;

Example
GRANT ALL ON *.* TO ‘horde’@’localhost’ identified by ‘password’;

Next run

Mysql> flush privileges; <–at the mysql prompt

test your mysql connect again with the first step if it works try in a browser, it should work now.

Cheers

Nick Tailor