Inability to Show Create View

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
When I execute the command "show create view" while logged in as root I
get this error:
  "select  command denied to user 'root'@'%' for column (a table that
from which the view draws part of its data)"

I can select the data from the column using the standard select syntax.
  I can also get the data from the view itself by running it using the
normal select syntax.

I presume there is some corruption here.  I am unable to find a way to
repair a view in a manner similar to optimizing or repairing a table.

Re: Inability to Show Create View

No bother wrote:
Quoted text here. Click to load it

Due to better searching I found that this is likely caused by Bug
#20482.  It is not a matter of corruption as I thought but rather a
problem internal to the engine that does not check the permissions
correctly.  According to the last entry it should be fixed in 5.0.25.

Site Timeline