Inability to Show Create View

[No bother]

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.

[No bother]

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.