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=sangpr...@gmail.com


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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to