CREATE ALGORITHM=UNDEFINED [email protected]`%` SQL SECURITY INVOKER VIEW…
When import the SQL file from localhost to remote server, if the server is shared or not given root access to your database the MySQL permission error will occur.
The problem is caused by the database that you are restoring to not having the correct database permissions to restore VIEWS. Look at the permissions on the database for the user. They need to have ‘CREATE VIEW’, ‘CREATE ROUTINE’ and ‘TRIGGERS’ permission.
The database where you have taken your export does have these permissions since the views are present in your backup.
This is not a specific problem with Issue Tracker but with the database permissions on the site you are restoring to.
You do not say what version of Issue Tracker you are using, but I suspect that this is version 1.3.4.
Depending upon the reason for the ‘restore’ process will determine the best course of action to follow next. If the destination is a live system and you cannot obtain/set the required database permissions, then I can let you know where to obtain a version of Issue Tracker that does not require these permissions. [You may need to modify the backup criteria to exclude views, triggers, and procedures.] If the destination can have these permissions set/changed, then this is the best way to go.
MySql Error: #1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Fixed Solution:
you can create a user called root in RDS, and use root to run the command, or simply
