List:General Discussion« Previous MessageNext Message »
From:Jigal van Hemert Date:May 5 2014 9:12am
Subject:Re: mysql Access denied error
View as plain text  
Hi,

On 5-5-2014 10:57, Reindl Harald wrote:
>
>
> Am 05.05.2014 10:19, schrieb Manuel Arostegui:
>> 2014-05-05 10:00 GMT+02:00 Reindl Harald <h.reindl@stripped
> <mailto:h.reindl@stripped>>:
>>
>>      Am 05.05.2014 08:34, schrieb Manuel Arostegui:
>>      > "%" doesn't match localhost so if you don't specify it you will be
>>      > attempting to connect via Unix Socket.
>>      > If you don't want to specify -hlocalhost all the time, just do the
> grant
>>      > with "@localhost" instead of "@%"
>>
>>      nonsense
>>
>>      % matches *any host*
>>
>> Do the test yourself
>
> i don't need to test such basics since i am working
> as mysql administrator the last 11 years and curently
> responsible for some hundret databases heavily using
> host specific permissions
>
> http://dev.mysql.com/doc/refman/5.5/en/connection-access.html
> '%'	'fred'	fred, connecting from any host

In that case you would know that connecting via a Unix socket is not the 
same as connection via a network.

See:
http://bugs.mysql.com/bug.php?id=69570
http://dev.mysql.com/doc/refman/5.5/en/connecting.html


-- 
Kind regards / met vriendelijke groet,

Jigal van Hemert.
Thread
mysql Access denied errorEdwardKing5 May 2014
  • Re: mysql Access denied errorManuel Arostegui5 May 2014
    • Re: mysql Access denied errorReindl Harald5 May 2014
      • Re: mysql Access denied errorManuel Arostegui5 May 2014
        • Re: mysql Access denied errorReindl Harald5 May 2014
          • Re: mysql Access denied errorJigal van Hemert5 May 2014
            • Re: mysql Access denied errorReindl Harald5 May 2014
          • Re: mysql Access denied errorManuel Arostegui5 May 2014
  • Re: mysql Access denied errorPeter Brawley5 May 2014
  • Re: mysql Access denied errorDivesh Kamra9 May 2014
Re: mysql Access denied errorJohan De Meersman5 May 2014
  • Re: mysql Access denied errorReindl Harald5 May 2014