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 +0000, Arne Mueller wrote: >Jeremy Zawodny wrote: >> >> On Sun, Jan 20, 2002 at 03:46:14AM +0000, 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 an error in your SQL syntax near '.Pseq read' at >> > line 1 >> > >> > Any idea what's wrong here? >> >> How about LOCK TABLES: >> >> http://www.mysql.com/doc/L/O/LOCK_TABLES.html >> >> Jeremy > > >Hello, > >Sorry, I realy did read this section in the manual, but somehow the >answer must be in between the lines ... I cannot find it :-( . So, >please be patient with the simple users and let me know the answer if >you know it. > >Also sorry for the above (quoted) syntax error of the command. Here >comes my problem: > >mysql> lock table develop.Pseq write; >ERROR 1142: select command denied to user: 'bmm@localhost' for table >'Pseq' > >User 'bmm' is allowed to connect to from localhost but only has >'process' and 'reload' privileges in the ,ysql.user table, the db table >then allows this user everything with the 'develop' db. Root (who has >all privileges in the mysql.user table is alowed to lock tables). > > thanks alot, > > Arne > >-- >Arne Mueller >Biomolecular Modelling Laboratory >Imperial Cancer Research Fund >44 Lincoln's Inn Fields >London WC2A 3PX, U.K. >phone : +44-(0)207 2693405 | fax :+44-(0)207-269-3534 >email : [EMAIL PROTECTED] | http://www.bmm.icnet.uk > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Joseph Roth ( JB ) [EMAIL PROTECTED] _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php