From: Claudio Nanni Date: March 16 2012 11:45am Subject: Re: Can't connect as non-root user to database List-Archive: http://lists.mysql.com/mysql/226985 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=e0cb4efe2ea02aff2704bb5ac053 --e0cb4efe2ea02aff2704bb5ac053 Content-Type: text/plain; charset=ISO-8859-1 If you want to verify it is very easy: $ mysql --user=someone somedb (without -p) mysql> select user(); select current_user(); cheers Claudio 2012/3/16 Claudio Nanni > 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 > -- Claudio --e0cb4efe2ea02aff2704bb5ac053--