import failure at create algorithm
import failure at create algorithm
Contents hide
1 CREATE ALGORITHM=UNDEFINED DEFINER=root@`%` SQL SECURITY INVOKER VIEW…
2 MySql Error: #1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation
2.1 Share this:

CREATE ALGORITHM=UNDEFINED DEFINER=root@`%` 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

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `inventory_stock_1` AS SELECT DISTINCT `legacy_stock_status`.`product_id` AS `product_id`,`legacy_stock_status`.`website_id` AS `website_id`,`legacy_stock_status`.`stock_id` AS `stock_id`,`legacy_stock_status`.`qty` AS `quantity`,`legacy_stock_status`.`stock_status` AS `is_salable`,`product`.`sku` AS `sku` FROM (`cataloginventory_stock_status` `legacy_stock_status` JOIN `decg_catalog_product_entity` `product` ON(`legacy_stock_status`.`product_id` = `product`.`entity_id`)) ;

Fixed Solution:

The problem is you set definer as root, which is not your current running user, that’s why you need to SUPER privilege.
you can create a user called root in RDS, and use root to run the command, or simply
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY INVOKER
change to:
CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY INVOKER
read more about CURRENT_USER
Final SQL query looks like
CREATE ALGORITHM=UNDEFINED DEFINER=CURRENT_USER SQL SECURITY INVOKER VIEW `inventory_stock_1` AS SELECT DISTINCT `legacy_stock_status`.`product_id` AS `product_id`,`legacy_stock_status`.`website_id` AS `website_id`,`legacy_stock_status`.`stock_id` AS `stock_id`,`legacy_stock_status`.`qty` AS `quantity`,`legacy_stock_status`.`stock_status` AS `is_salable`,`product`.`sku` AS `sku` FROM (`cataloginventory_stock_status` `legacy_stock_status` JOIN `decg_catalog_product_entity` `product` ON(`legacy_stock_status`.`product_id` = `product`.`entity_id`)) ;
Thank you.
Read more about CSS here. border-radius

 

RELATED ARTICLESMORE FROM AUTHOR