Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
After much searching, this is the most info I could find on the  
Lock_tables_priv privilege in the mysql system database:

from mysql.com...
The LOCK TABLES privilege enables the use of explicit LOCK TABLES  
statements to lock tables for which you have the SELECT  privilege. This  
includes the use of write locks, which prevents anyone else from reading  
the locked table.

My question is does this have any effect on locks in transactions, i.e.  
as update locks, etc. used with InnoDB tables?  It seems like I should  
set this value to 'N' for most of my database users, but I just wanted  
to make sure this is talking about something different from transaction  
locking as I couldn't find that specific info out.  Thanks a bunch.

Re: Lock_tables_priv

Marcus wrote:
Quoted text here. Click to load it

You are correct - you generally want that set to 'N'.  It specifically  
addresses the LOCK TABLES command, and has no effect on internal locks  
generated by MySQL or INNODB.

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

Site Timeline