“It would be nice to have an option, that would allow to suppress the DEFINER statement in the CREATE VIEW statements generated by mysqldump. This would help when transferring data structures between databases with different security models.”  TLDR; Use mysqlpump with option[crayon-60ea140763bfb832115226-i/] instead of [crayon-60ea140763c05786943898-i/]. The Story This was requested as MySQL Bug #24680 on [&]

https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/