From: Claudio Nanni Date: March 16 2012 11:41am Subject: Re: Can't connect as non-root user to database List-Archive: http://lists.mysql.com/mysql/226984 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d04083f4bec8dba04bb5ab03a --f46d04083f4bec8dba04bb5ab03a Content-Type: text/plain; charset=ISO-8859-1 you probably have the anonymous user account taking over: ''@'localhost' 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) login as root and: mysql> drop user ''@'localhost'; and try again Cheers Claudio 2012/3/16 Clemens Eisserer > Hi Rik, > > > Hm, is the mysql-client library the same as the mysql-server? > Yes. > > > And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's > actual > > IP-address, forcing the TCP/IP connect instead of possible sockets) ? > > This is really strange - with -h127.0.0.1 I get the same error: > ERROR 1045 (28000): Access denied for user 'someone'@'localhost' > (using password: YES) > > However with -h192.168.1.102 everything works as expected, although I > used 'someone'@'%' everywhere. > Does '%' not include local connections / unix domain sockets? > > Thanks, Clemens > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- Claudio --f46d04083f4bec8dba04bb5ab03a--