How to change definer of a mysql view!!!
I want to see a mysql "view" but mysql is not showing me the view, but showing a error :
" #1449 - The user specified as a definer ('user'@'localhost') does not exist "
Now please can anybody tell me, how i can alter the definer of a mysql view with "root@localhost" !! how can i make it possible. Thanks in advance !!!!
Or if there is any other way to change it,please inform me!!!
Subject
Written By
Posted
How to change definer of a mysql view!!!
August 03, 2011 06:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.