List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:June 20 2011 1:42pm
Subject:Re: access from everywhere but localhost?
View as plain text  
Nope, for example you can assign access to db1.* to user1@stripped.% which
doesn't include localhost or 127.0.0.1.
On 20 Jun 2011 14:35, "Matthias Leopold" <matthias@stripped> 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" <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
> ------------------------------------------------

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