[thelist] [MySQL] privilege level need to DECSCRIBE table

[Paul Bennett]

Hi Yasser,

I did take a look at that article before I posted and unfortunately it doesn't directly answer my question.
It turns out the issue was a db upgrade:

<tip type="cakephp and mysql3 v cakephp and mysql5">
If you're using a describe statement in a cakephp query it will retun a differently formatted array depending upon which version of mysql you're using.
</tip>

-----Original Message-----
From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Yasser Chaudhri
Sent: Tuesday, April 22, 2008 1:24 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] [MySQL] privilege level need to DECSCRIBE table


Please check out this article:

http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-security-mysql-privileges.html

Regards, YC
============================
> From: Paul.Bennett at wcc.govt.nz> To: thelist at lists.evolt.org> Date: Tue, 22 Apr 2008 11:36:08 +1200> Subject: [thelist] [MySQL] privilege level need to DECSCRIBE table> > Hi all,> > I have a user account for an application which has select, insert, update, delete privileges, but this doesn't seem to allow DESCRIBE statements to be run. Does anyone know the minimum extra privilege needed to allow a user account to run a describe?> > :)> Paul> -- > > * * Please support the community that supports you. * *> http://evolt.org/help_support_evolt/> > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt !
--

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !