I've setup a mail server on an Ubuntu 14.04 server. I've installed Courier as the IMAP server and I've configured it so it can connect to MySQL and use its data as the user list and stuff.
I've already managed to configure Courier once to connect to MySQL on another machine. But right now I'm having problem doing it again on another machine.
Tailing the /var/log/mail.log
file I can see that Courier can not connect to MySQL:
authdaemond: authmysql: mysql_select_db(MyDb) error: Access denied for user 'MyUser'@'192.168.1.10' to database 'MyDb'
It's in the case that I can connect to mysql server from the shell of the same machine using mysql client, with the same credential as given to Courier! How can this be possible?