stored-programs-security

This page has moved or been replaced. The new page is located here:

http://dev.mysql.com/doc/refman/5.5/en/stored-objects-security.html

Please update any bookmarks that point to the old page.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
  Posted by Howard Walker on November 23, 2013
If you ever create a view with the default root user, you will find that it will not be possible to upload it to a shared hosting account. Use the username that your web site will use to log on to the site to define your view.
If you need to re-create your view with a new definer,or just with a definer if, for instance, you are changing from 5.1 to 5.5, make sure that you have the original view creation script to hand. So far after weeks of searching this site, I have not as yet found a way to change the definer of a view.
Howard Walker