[SOLVED] Can't connect to database on WHM/CPanel server

[chillifish]

Trying to move a perfectly working site to my WHM server. When I have transferred files, imported database and changed config.php, I am greeted with the following message:

Fatal error: Attempt to connect to database chilli_frog on chilli_frog@localhost failed in /home/chilli/public_html/proof/frogmorefarm/lib/adodb.functions.php on line 61

When I try a fresh install of CMS Made Simple, I get the following error at step 5 of the install:

Could not connect to the database. Verify that username and password are correct, and that the user has access to the given database.

I have checked, double checked, triple checked, quadruple checked, changed, deleted and re-setup the database and user. phpMyAdmin can see, edit and browse the database fine.

[Rolf]

clear cache, delete all files in tmp/templates_c and tmp/cache folders

[chillifish]

Thank you, thank you, thank you. I've been tearing my hair out over this. Now working fine.

[burlington]

I am getting a similar sort of message viz:
<quote>
Database Connection Failed
Error: Access denied for user 'xxxx'@'213.171.218.116' (using password: YES) (1045)
Function Performed: CONNECT

Fatal error: Attempt to connect to database perfectday1 on perfectday1@88.208.244.124 failed in E:\domains\p\xxxx\user\htdocs\newsite\lib\adodb.functions.php on line 61
</quote>

I have cleared the files etc as recommended by Rolf but I still get the same message. I can't clear the cache via the admin. system as I can't get in. System worked fine 24 hours ago.

Can anyone help please?

Thanks

Martin

[Jeff]

Please start a new topic, don't hijack an old solved topic.

Jeff

[burlington]

I think hijack is a shade strong. In any case, I DID start a new topic at http://forum.cmsmadesimple.org/viewtopi ... =3&t=71451