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 <linuxhi...@gmail.com>

> 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

Reply via email to