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" <sangpr...@gmail.com <mailto:sangpr...@gmail.com>> 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=sangpr...@gmail.com >> > > 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=eroomy...@gmail.com >
-- 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