Inability to Show Create 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:
> 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.

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.