Database Connection Error

Symptoms :-
Getting "Database Connection Error" while accessing Atmail webmail by webmail.domain.com


Error :-
Quote:
Database Connection Error
DB Error: connect failed

* Verify the SQL database is running

* Check the SQL server is listening to the specified socket, IP address

* Check the global configuration file (/var/www/atmail/libs/Atmail/Config.php) for the correct database details

* Verify the database server is running correctly

* Verify the MySQL /etc/my.cnf file has the correct settings for the number of database connections

Cause :- Password for the mysql user atmail is not correct as per mentioned in Atmail password file.

[root@support007 ~]# cat "/etc/psa-webmail/atmail/.atmail.shadow"
d62kgaczkOmrqP [This is the password of mysql user admin]


[root@support007 ~]# mysql -uatmail -p
Enter password: [Here I have used d62kgaczkOmrqP password for login as user atmail it fails as password of the user is not correct]
ERROR 1045 (28000): Access denied for user 'atmail'@'localhost' (using password: YES)


Solution :-
Just reset the password for mysql user atmail as per mentioned in atmail password file "/etc/psa-webmail/atmail/.atmail.shadow"