When you create Mysql store procedure with query and then got error message as below
MySQL said:
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
To solve this problem, please replace " root" to your current database user to your query like
CREATE DEFINER=`9df99f_w424_1`@`%` PROCEDURE `GetImages`( in search Varchar(80) ) BEGIN select image_path from check_images where checkNumber=search; END
Actually, there is another solution. All you need to do is remove the DEFINER portion of your statement. Then it will automatically use the current user.
Article ID: 370, Created: March 25, 2013 at 11:34 PM, Modified: March 5, 2016 at 1:42 AM