List:General Discussion« Previous MessageNext Message »
From:Matthias Leopold Date:June 20 2011 1:32pm
Subject:Re: access from everywhere but localhost?
View as plain text  
this of course removes access from everywhere which is not want i want

regards
matthias

Am 2011-06-20 15:19, schrieb Willy Mularto:
> 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)
>
>
>
>
>
>
>


-- 
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