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.
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
