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 <matth...@aic.at> > 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.na...@gmail.com<http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com> > > -- Claudio
