Nope, for example you can assign access to db1.* to user1@192.168.% which
doesn't include localhost or 127.0.0.1.
On 20 Jun 2011 14:35, "Matthias Leopold" <matth...@aic.at> wrote:
> 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" <sangpr...@gmail.com
>> <mailto:sangpr...@gmail.com>> 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=sangpr...@gmail.com
>> >>
>> >
>> > 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=eroomy...@gmail.com
>> >
>
>
> --
> 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
> ------------------------------------------------
