Thanks for the answer. ZK --- On Wed, 2/17/10, Mikhail Berman <mikhail...@gmail.com> wrote:
> From: Mikhail Berman <mikhail...@gmail.com> > Subject: Re: Information_schema permission error > To: "Zakai Kinan" <titanyen2...@yahoo.com> > Cc: mysql@lists.mysql.com > Date: Wednesday, February 17, 2010, 5:49 AM > On 02/16/2010 17:30, Zakai Kinan > wrote: > > I am getting this error - mysqldump: Got error: 1044: > Access denied for user 'root'@'localhost' to database > 'information_schema' when using LOCK TABLES. I am > using 5.1.45. I don't understand what is causing this > problem. Does anyone have a clue? > > > > TIA, > > > > > > Zak > > > > > > > > > > > Hi Zak, > > information_schema database is not a set of real tables, it > is a set of > views - http://dev.mysql.com/doc/refman/5.1/en/information-schema.html, > > and because of that you cannot backup information_schema > tables as there > are not any. > > The error message you are getting is simply confusing and > incorrectly > represents the situation. > > Hoping this helps > > Mikhail Berman > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
