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
