Bug 307305

Summary:	dev-db/mysql-5.1.44 mysqldump can not be used to dump the information_schema table
Product:	Gentoo Linux	Reporter:	Dan Coats <admin>
Component:	[OLD] Server	Assignee:	Gentoo Linux MySQL bugs team <mysql-bugs>
Status:	RESOLVED UPSTREAM
Severity:	normal
Priority:	High
Version:	unspecified
Hardware:	All
OS:	Linux
URL:	http://bugs.mysql.com/bug.php?id=49633
Whiteboard:	UPSTREAM
Package list:		Runtime testing required:	---

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) gentoo-dev

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 archtester

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) Gentoo Infrastructure

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) Gentoo Infrastructure

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) Gentoo Infrastructure

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 archtester

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.