List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:May 5 2014 9:27am
Subject:Re: mysql Access denied error
View as plain text  

Am 05.05.2014 11:12, schrieb Jigal van Hemert:
> 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

i know that, but it does not change the fact that here
are mysql users in production which are using % and
accessed via localhost unix-socket as well as via
TCP from remote-machines with mysql-over-ssl

maybe MariaDB don't have that bug and it is a bug
if you can't connect with a user specified with %
over the unix-socket independent what some guy
from Oracle pretends



Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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