On 16. Feb 2025, at 6.33, Ken Wright via dovecot <dovecot@dovecot.org> wrote:
On Sat, 2025-02-15 at 18:31 -0500, Doug via dovecot wrote:
" Access denied for user.. 'dovecot'@'localhost' "
Is a mysql error. mysql isn't allowing the user dovecot to open the database to run your SQL query. Until you can open the database, you aren't even retrieving the account password. That is where you should concentrate your efforts. I don't use mysql for authentication so I can't really tell you how to configure dovecot or mysql to make it work.
This makes sense. What doesn't make sense (to me at least) is why Dovecot is trying to connect using the user 'dovecot' when I specified a different user in dovecot.conf. (Forgive me for not disclosing the actual user name.) Is there a setting for mysql user I need to correct? What is the correct syntax, anyway?
Maybe you're missing all the mysql settings?
mysql localhost { user = something password = something-else }
https://doc.dovecot.org/2.4.0/core/config/sql/mysql.html lists all the mysql settings.
Yeah, would be nice to have some examples in docs.