Bug #1420 Please enable table locking permission by default
Submitted: 28 Sep 2003 15:55 Modified: 28 Oct 2003 16:17
Reporter: Ilia Alshanetksy Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:4.0+ OS:Any (Any)
Assigned to: CPU Architecture:Any

[28 Sep 2003 15:55] Ilia Alshanetksy 
Description:
In MySQL 3.23 and lower the default configuration allowed users to lock 
tables. As of MySQL 4.0 this is no longer the case and the admin has to 
explicitly grant that (LOCK) permission. While relatively few applications use 
this, there are a fair number of those who do. Since majority of users use the 
default settings and are unable to change the setting themselves or convince 
their server provider to do so they loose the ability to use applications 
reliant on table locks. 
Please consider enabling table lock permission by default. 

How to repeat:
not applicable.
[28 Sep 2003 16:17] Paul DuBois 
It was only true in the first few releases of 4.0.x that
the Lock_tables_priv was off by default for the initial
accounts. This problem was fixed some time ago.

What version are you using?
[14 Feb 2005 22:54] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".