Thanks for your reply. I repeated your test with the same results on 4.1.21
(database in question is on 4.1). I'll give the ISP another kick and see what
they have to say.
So there's no other reason why an ISP might not want to grant LOCK TABLES in a
shared hosting environment?
Thanks,
James
I am not aware of any such bug related to the LOCK TABLES privilege.
Like you I could not find a mention in our bugs database, for any version.
It is easy to demonstrate that this is not the case. If permissions are
properly set up, LOCK TABLES can be restricted to a database just like
every o
I'm using MySQL as the db for Drupal (PHP based CMS), on shared hosting. There
are repeated errors because the db user does not have permission for LOCK
TABLES, which Drupal uses.
The ISP says that they don't grant this permission because ...
"MySQL has a bug which allows users with GrantTables
It is not a bug.
As soon as Computer1 releases the lock,
Computer2 will have its query processed.
Never write a program that keeps a lock for more than a few miliseconds.
Eric Cotting wrote:
> MYSQL Server: 3.23.49a-log
> MYSQL Client: 3.23.3 alpha
> MYSQLGUI: 1.7.5
> Operating System: Windows N
MYSQL Server: 3.23.49a-log
MYSQL Client: 3.23.3 alpha
MYSQLGUI: 1.7.5
Operating System: Windows NT, Windows 2000
When I place a table lock on a table with one computer and issue a query
on another while the lock is in affect, the computer that issues the
query halts execution of the query with
