[Dovecot] Failed authentication to a mysql database (bug or PEBKAC?)

[Timo Sirainen]

On 15.8.2005, at 12:21, Michael Gabb wrote:

> I inserted this few lines just before the "mysql_real_connect()" and
> alle I get ist correct output (means: "User -> my_user, Password ->
> my_password")

I can't really then say why it doesn't work. If everything gets sent 
right to mysql_real_connect(), then it's all mysql's job from there 
on.. If it works with 0.99.x, is it maybe using a different version of 
mysql library?

> 24558 open("/usr/share/mysql/charsets/Index.xml", 
> O_RDONLY|O_LARGEFILE) = 8

This brings to my mind that are aren't any non-ascii characters in the 
user/password?

> 24558 read(7, "\377\25\4#28000Access denied for user "..., 75) = 75

Mysql logs don't say more specific reason why it won't work?

Hmm. Maybe it's not user/password itself, but the database that you're 
connecting to isn't right?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20050815/81d0359a/PGP.pgp