From: Andrew Moore Date: June 20 2011 1:42pm Subject: Re: access from everywhere but localhost? List-Archive: http://lists.mysql.com/mysql/225311 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=90e6ba4fbe80127e9a04a624e768 --90e6ba4fbe80127e9a04a624e768 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Nope, for example you can assign access to db1.* to user1@stripped.% which doesn't include localhost or 127.0.0.1. On 20 Jun 2011 14:35, "Matthias Leopold" wrote: > 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" > > 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=3Dsangprabv@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=3Deroomydna@stripped= om >> > > > > -- > Mit freundlichen Gr=FCssen > > Matthias Leopold > System & Network Administration > > Streams Telecommunicationsservices GmbH > Universitaetsstrasse 10/7, 1090 Vienna, Austria > > tel: +43 1 40159113 > fax: +43 1 40159300 > ------------------------------------------------ --90e6ba4fbe80127e9a04a624e768--