Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'caaleor'@'localhost' (using password: YES) in /home/caaleor/public_html/main/system/databases/mysql.class.php on line 112
Cannnot connect to DB server


I have used the same database password for years until my host provider said that there server compromised my password or something and they changed it. My question is how do I fix this problem.

Thanks in advance

Sounds like they need to tell you what's its been changed to and you need put the new password in your config.php.