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
 
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.