does this mean that "access from everywhere but localhost" is impossible?
matthias
Am 2011-06-20 15:22, schrieb Andrew Moore:
> Grant only to the hosts you want to have access to your data.
>
> Andy
>
> On 20 Jun 2011 14:20, "Willy Mularto" <sangprabv@stripped
> <mailto:sangprabv@stripped>> wrote:
> > Replace GRANT with REVOKE
> >
> >
> >
> > On Jun 20, 2011, at 8:08 PM, Matthias Leopold wrote:
> >
> >> 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
> <http://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=1
> >>
> >
> > Willy Mularto
> > F300HD+MR18DE (NLC1725)
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> >
--
Mit freundlichen Grüssen
Matthias Leopold
System & Network Administration
Streams Telecommunicationsservices GmbH
Universitaetsstrasse 10/7, 1090 Vienna, Austria
tel: +43 1 40159113
fax: +43 1 40159300
------------------------------------------------
