Re: SELECT records less than 15 minutes old

2011-06-20 Thread sono-io
On Jun 20, 2011, at 10:11 AM, Jerry Schwartz wrote: >> You should use UTC time zone or you will run into trouble with DST. >> > [JS] If you do that, you can't use an automatic timestamp field. You have to > set the field yourself. Thanks Walter and Jerry. Is there a way to get

RE: SELECT records less than 15 minutes old

2011-06-20 Thread Jerry Schwartz
>-Original Message- >From: walter harms [mailto:wha...@bfs.de] >Sent: Monday, June 20, 2011 7:07 AM >To: sono...@fannullone.us >Cc: mysql@lists.mysql.com >Subject: Re: SELECT records less than 15 minutes old > > > >Am 19.06.2011 21:06, schrieb sono...@fannullone.us: >> On Jun 19, 2011, at 1

Re: access from everywhere but localhost?

2011-06-20 Thread Claudio Nanni
MySQL works on a ALLOW scheme, and since % contains all you need to specify a more specific 'rule'. you can use this dirty trick: GRANT USAGE ON `xxx`.* TO 'yyy'@'127.0.0.1' identified by 'impossible-password'; GRANT USAGE ON `xxx`.* TO 'yyy'@'localhost' identified by 'impossible-password'; Chee

Re: access from everywhere but localhost?

2011-06-20 Thread Andrew Moore
Nope, for example you can assign access to db1.* to user1@192.168.% 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:

Re: access from everywhere but localhost?

2011-06-20 Thread Matthias Leopold
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" mailto:sangpr...@gmail.com>> wrote: > Replace GRANT with REVO

Re: access from everywhere but localhost?

2011-06-20 Thread Matthias Leopold
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 privile

Re: access from everywhere but localhost?

2011-06-20 Thread 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 privilege

Re: access from everywhere but localhost?

2011-06-20 Thread 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 everywhere but localhost?

2011-06-20 Thread Matthias Leopold
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

Re: SELECT records less than 15 minutes old

2011-06-20 Thread walter harms
Am 19.06.2011 21:06, schrieb sono...@fannullone.us: > On Jun 19, 2011, at 11:11 AM, Claudio Nanni wrote: > >> just a quick debug: > > Thanks, Claudio. It turned out to be that NOW() was using the server's > time and my timestamp was based on my timezone. After fixing that, the > SELEC