KidCock

I solved the trouble. It seems just the auth_mysql module itself is buggy, I installed an alternate one from FreeBSD ports:

/usr/ports/www/mod_auth_mysql_another/

and it works perfectly right away without any other changes on the server =)