Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Inability to Show Create View
- No bother
August 15, 2006, 4:26 pm
rate this thread
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
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.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum