Page 1 of 1

MySQL Error: [Access denied for user 'mailwatch'@'localhost' (using password: YES)]

Posted: 17 Feb 2019, 12:59
by mojocreator
When I try to access ConfigServer MailScanner Front-End v8.23 via WHM I get the following error.

MySQL Error: [Access denied for user 'mailwatch'@'localhost' (using password: YES)]

In /var/log/maillog i am also getting the following error

MailScanner: Unable to initialise MailControl database connection: %%CBCB8KR33FFS7M0MOGPCSZJCMSH0N6FTE3O0HHB61D412VPQKWM

Re: MySQL Error: [Access denied for user 'mailwatch'@'localhost' (using password: YES)]

Posted: 27 Jan 2020, 14:08
by syedc
For anyone else watching this thread in the future, I had the same issue. Upon further investigation, it was being caused by MSFE db's user p/w not being as strong as my password policies (needed a symbol).

I solved the issue by:

Changing the database user password for mailscanner, in the file: /usr/mscpanel/mailcontrol/mailcontrol.txt

And then in console:
$ mysql
$ CREATE USER 'mailwatch'@'localhost' IDENTIFIED BY 'PASSWORD_HERE';
$ GRANT ALL ON mailscanner.* TO 'mailwatch'@'localhost';