Re: Can't connect as non-root user to database

[Clemens Eisserer]

Hi Claudio,

> you probably have the anonymous user account taking over:   ''@'localhost'
> login as root and:
> mysql> drop user ''@'localhost';
Thanks a lot, that solved the problem (and saved my day :) !).


> when you specify the host with -h you are actually forcing MySQL to use
> TCP/IP so it will authenticate you using your ip address (127.0.0.1)
Actually even with -h127.0.0.1 specified, I got "access denied for
...@localhost".

Thanks again, Clemens