List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:June 20 2011 1:22pm
Subject:Re: access from everywhere but localhost?
View as plain text  
Grant only to the hosts you want to have access to your data.

Andy
On 20 Jun 2011 14:20, "Willy Mularto" <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?
>>
>> 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
>

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