List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:June 20 2011 2:02pm
Subject:Re: access from everywhere but localhost?
View as plain text  
MySQL works on a ALLOW scheme, and since % contains all you need to specify
a more specific 'rule'.

you can use this dirty trick:

GRANT USAGE ON `xxx`.* TO 'yyy'@'127.0.0.1' identified by
'impossible-password';
GRANT USAGE ON `xxx`.* TO 'yyy'@'localhost' identified by
'impossible-password';

Cheers

Claudio



2011/6/20 Matthias Leopold <matthias@stripped>

> hi,
>
> this surely is a beginners question:
>
> i already created a user and privileges like this:
>
> GRANT ALL PRIVILEGES ON `xxx`.* TO 'yyy'@'%' identified by 'zzz';
>
> how do i modify this setup to remove access from localhost/127.0.0.1?
>
> mysql version is 5.1.49
>
> thx
> matthias
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?**
> unsub=claudio.nanni@stripped<http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Claudio

Thread
access from everywhere but localhost?Matthias Leopold20 Jun
  • Re: access from everywhere but localhost?Willy Mularto20 Jun
    • Re: access from everywhere but localhost?Andrew Moore20 Jun
      • Re: access from everywhere but localhost?Matthias Leopold20 Jun
        • Re: access from everywhere but localhost?Andrew Moore20 Jun
    • Re: access from everywhere but localhost?Matthias Leopold20 Jun
  • Re: access from everywhere but localhost?Claudio Nanni20 Jun