Re: permission to lock tables

2002-01-20 Thread Joseph Roth
I believe the correct command is LOCK TABLES with an 'S' at the end. your quoted command says LOCK TABLE without the 'S'. HTH At 04:15 PM 1/20/2002 +, Arne Mueller wrote: >Jeremy Zawodny wrote: >> >> On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote: >> > Hi All, >> > >> > I've j

Re: permission to lock tables

2002-01-20 Thread Arne Mueller
Jeremy Zawodny wrote: > > On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote: > > Hi All, > > > > I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a > > few minutes ago there is a strange problem I've never had in mysql > > version 3: > > > > mysql> lock table .dev

Re: permission to lock tables

2002-01-19 Thread Jeremy Zawodny
On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote: > Hi All, > > I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a > few minutes ago there is a strange problem I've never had in mysql > version 3: > > mysql> lock table .develop.Pseq read; > ERROR 1064: You have

permission to lock tables

2002-01-19 Thread Arne Mueller
Hi All, I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a few minutes ago there is a strange problem I've never had in mysql version 3: mysql> lock table .develop.Pseq read; ERROR 1064: You have an error in your SQL syntax near '.Pseq read' at line 1 Any idea what's wrong