Re: [Fez-users] MySQL error

[Lynette R. <el...@cs...>]

We figured this out.  I thought we were using MySQL 5, but it turns out we
have 4.1.

 

L-

 

________________________________

From: fez...@li...
[mailto:fez...@li...] On Behalf Of Lynette Rayle
Sent: Monday, May 05, 2008 3:39 PM
To: fez...@li...
Subject: [Fez-users] MySQL error

 

Since upgrading to Rev1597, I am getting a MySQL error that I'm not having
any luck resolving.

 

#1044 - Access denied for user 'XXX'@'localhost' to database
'Information_schema'

 

NOTE: XXX is not the real user name.  It is obscured here, but is correct at
the time the query is attempted.

 

Query:

SELECT count(*) as cnt

          FROM Information_schema.columns

          WHERE table_schema = 'fez14'

              AND table_name = 'fez_record_search_key'

              AND column_name = 'rek_'

 

MySQL document states...

 

"INFORMATION_SCHEMA provides access to database metadata"

 

And...

 

"There is no difference between the privileges required for |SHOW| statements
and those required to select information from |INFORMATION_SCHEMA|. In either
case, you have to have some privilege on an object in order to see
information about it."

 

All other queries are operating as expected.  If anyone can provide help on
resolving this issue, it would be appreciated.

 

Lynette