Bug 307305 – dev-db/mysql-5.1.44 mysqldump can not be used to dump the information_schema table

• Status: RESOLVED UPSTREAM
• Product: Gentoo Linux

[Description Dan Coats 2010-03-01 13:29:16 UTC]

mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES

Reproducible: Always

Steps to Reproduce:
1.Try to dump all databases.
2.
3.

Actual Results:  
mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES


Shouldnt the provided patch be applied?
http://bugs.mysql.com/file.php?id=9236

[Comment 1 Brian Evans (RETIRED) 2010-03-16 20:19:08 UTC]

I'm no expert, but did you see the doc at the end of that upstream bug?

"Currently, this requires that the --skip-lock-tables (or --skip-opt) option be given."

[Comment 2 Robin Johnson 2010-03-23 23:26:46 UTC]

1. The patch you linked is already present.
2. More reading the bug would indicate that upstream has NOT yet fixed all the rest of the issue.

URL updated now.

[Comment 3 Jorge Manuel B. S. Vicetto (RETIRED) 2011-10-30 00:01:20 UTC]

Looking at the linked upstream bugs, seems this issue has yet to be fixed or confirmed as fixed.

[Comment 4 Jorge Manuel B. S. Vicetto (RETIRED) 2012-09-10 14:46:44 UTC]

The upstream bug is "dead". There was no activity since 2009.
Time to close it as "CANTFIX"?

[Comment 5 Jorge Manuel B. S. Vicetto (RETIRED) 2013-10-08 01:52:55 UTC]

(In reply to Jorge Manuel B. S. Vicetto from comment #4)
> The upstream bug is "dead". There was no activity since 2009.
> Time to close it as "CANTFIX"?

The "silence" on upstream bug continues.

@Robin:
Time to close as CANTFIX?

[Comment 6 Robin Johnson 2013-10-08 02:45:16 UTC]

(In reply to Jorge Manuel B. S. Vicetto from comment #5)
> (In reply to Jorge Manuel B. S. Vicetto from comment #4)
> > The upstream bug is "dead". There was no activity since 2009.
> > Time to close it as "CANTFIX"?
> The "silence" on upstream bug continues.
> @Robin:
> Time to close as CANTFIX?
There is an upstream bug I opened in early 2008 that recently got fixed; but RESO UPSTREAM is probably be best action on this bug for now.

We don't need to keep it open.