CREATE ALGORITHM=UNDEFINED DEFINER In MySQL

Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

When try to import SQL file with below query on server

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mobile_registered_view`.....;



Solution:

CREATE VIEW `mobile_registered_view`

OR

CREATE ALGORITHM=UNDEFINED DEFINER=`control_panel_username`@`localhost`