From: Claudio Nanni (claudio.nannigmail.com)
Date: Fri Mar 16 2012 - 06:45:52 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <claudio.nannigmail.com>

> 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 <linuxhippygmail.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
>

--
Claudio

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]