Re: permission to lock tables
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 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
Re: permission to lock tables
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 .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
Re: permission to lock tables
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 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 -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 17 days, processed 406,741,655 queries (272/sec. avg) - 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
permission to lock tables
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? thanks a lot for help, Arne user name is 'bmm', here's the ysql table: mysql> select * from user where user = 'bmm' and Host = 'localhost'; +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ | localhost | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | Y| Y | N | N | N | N | +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ mysql> select * from user where user = 'bmm'; ++--+--+-+-+-+-+-+---+-+---+--+---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | ++--+--+-+-+-+-+-+---+-+---+--+---++-+++ | localhost | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | Y| Y | N | N | N | N | | %.lif.icnet.uk | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | Y| Y | N | N | N | N | | %.mimcluster | bmm | 006d987861784d38 | N | N | N | N | N | N | Y | N | N| N | N | N | N | N | ++--+--+-+-+-+-+-+---+-+---+--+---++-+++ mysql> select * from host where Host = 'localhost'; +---++-+-+-+-+-+---++-+++ | Host | Db | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---++-+-+-+-+-+---++-+++ | localhost | % | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +---++-+-+-+-+-+---++-+++ -- 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
