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

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


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