Mysql Procedure Error (execute command denied to user)

Question

Create procedure:

CREATE DEFINER=`gnysoftxuser`@`%` PROCEDURE `insertadmin`(IN  adi  VARCHAR(150))BEGIN Insert Into mekan_tablo (mekan_adi) values (adi); END;

Mysql query

CALL insertadmin('test');

Mysql error:

execute command denied to user 'gnysoftxuser'@'%'for routine 'xdb.insertadmin'

Answer 1

That means that the MySQL user that you are connecting with does not have the EXECUTE priviledge for the database. https://dev.mysql.com/doc/refman/5.5/en/privilege-system.html