Related Documentation Download this Manual
PDF (US Ltr) - 45.3Mb
PDF (A4) - 45.3Mb
PDF (RPM) - 40.9Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 208.4Kb
Man Pages (Zip) - 310.6Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

stored-programs-security

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

http://dev.mysql.com/doc/refman/8.0/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