tag:blogger.com,1999:blog-8007802080401497299.post401349363267325571..comments2022-09-06T11:35:46.245-07:00Comments on MySQL Mate & Maté: TIL: Lookout For DEFINERGerry Narvajahttp://www.blogger.com/profile/14092453914112673024noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8007802080401497299.post-41706198265316775562012-04-16T02:10:58.487-07:002012-04-16T02:10:58.487-07:00Genius! All my views were created with root@localh...Genius! All my views were created with root@localhost DEFINER. I moved to a Plesk server that only had admin@localhost. Then your normal DB users can't access the views, not because they don't have permissions but because the DEFINER account didn't exist.Unknownhttps://www.blogger.com/profile/01776200531001714771noreply@blogger.com