Re: Connect failed to database

[Reindl Harald]

Am 02.03.2015 um 19:53 schrieb Dan LaSota:

still doesn't work:
Mar  2 04:58:48 mail dovecot: auth-worker(5745): Error: mysql(127.0.0.1): 
Connect failed to database (servermail): Access denied for user 
'usermail'@'localhost' (using password: YES) - waiting for 1 seconds before 
retry

that is a pretty clear message

the username / password / host is wrong, fix your mysql permissions and keep in 
mind that localhost != 127.0.0.1 in that context

which is the preferred address: localhost or 127.0.0.1 ?

depends

if you prefer unix sockets: localhost
if you prefer TCP: 127.0.0.1

the user with that password from that host is not allowed - period

Then why can I use the same credentials to log into mysql from the command 
line? Like so:

# mysql -u mailuser -h localhost -p

that is unix-socket, -h 127.0.0.1 would be TCP

just use "host=/var/lib/mysql/mysql.sock" or wherever your socket lives or give the 127.0.0.1 user the same permissions - these are mysql basics

signature.asc
Description: OpenPGP digital signature