From: Claudio Nanni Date: March 16 2012 7:10pm Subject: Re: Can't connect as non-root user to database List-Archive: http://lists.mysql.com/mysql/226998 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d04308a282a34f104bb60f5c2 --f46d04308a282a34f104bb60f5c2 Content-Type: text/plain; charset=ISO-8859-1 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 > 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 --f46d04308a282a34f104bb60f5c2--