List:General Discussion« Previous MessageNext Message »
From:Matthias Leopold Date:June 20 2011 1:34pm
Subject:Re: access from everywhere but localhost?
View as plain text  
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