Hi Clemens, my pleasure!
I forgot, you had to use also -P3306, so using both -h and -P which deny the lookup for users at localhost, forcing TCP-IP. and so IPs. this is also good when the socket file is not in the standard location, you will have the same problem logging in locally, using -h and -P forces TCP-IP Cheers! Claudio 2012/3/16 Clemens Eisserer <linuxhi...@gmail.com> > 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 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- Claudio
