Databases
Create Mysql store procedure got error---#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Databases > MySQL
When you create Mysql store procedure with query and then got error message as below
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.
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.