Bug #55019 can't dump without LOCK TABLE privilege

• Submitted: 6 Jul 2010 6:28
• Modified: 1 Sep 2010 14:52
• Reporter: Aleksey Khudyakov
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S2 (Serious)
• Version: 5.2.25
• OS: Any (win 7, Mac OS X)
• Assigned to: Alfredo Kojima
• CPU Architecture: Any

[6 Jul 2010 6:28] Aleksey Khudyakov

Description:
Can't dump table/schema without LOCK TABLE privilege.
"mysqldump: Got error: 1044: Access denied for user 'wwroot'@'%' to database db' when doing LOCK TABLES"

Ps: add-locks checkbox deselected, though it unrelated to this issue

How to repeat:
dump table/schema without LOCK TABLE privilege.

Suggested fix:
Add check for LOCK TABLE privilege. If privilege not set then skip lock table directive.

[6 Jul 2010 6:52] Valeriy Kravchuk

Thank you for the bug report. Verified just as described on Mac OS X.

[20 Aug 2010 3:34] Alfredo Kojima

Added lock-tables to Advanced Options

[25 Aug 2010 19:29] Johannes Taxacher

fix confirmed in repository

[1 Sep 2010 14:52] Tony Bedford

An entry has been added to the 5.2.27 changelog:

It was not possible to dump tables or schemata without the LOCK TABLE privilege. The following error was generated:

mysqldump: Got error: 1044: Access denied for user 'wwroot'@'%' to database db' when
doing LOCK TABLES