Information_schema permission error

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




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Information_schema permission error

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.ht ml,
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=gcdmg-mysql-2@m.gmane.org

Re: Information_schema permission error

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg