"Access denied for user" error when creating a procedure

1 vote

1 answer

9052 views

mysql stored-procedures permissions procedure-definition

                          When I request my database server (MySQL), with "show grants for current_user"

I notice that I have the grant to execute procedure:

    SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, EXECUTE 

But when I execute a sql file that contains those instructions : 

    DROP FUNCTION IF EXISTS 
    DROP FUNCTION IF EXISTS 
    DROP PROCEDURE IF EXISTS
    CREATE FUNCTION 
    CREATE PROCEDURE
    DECLARE
    CALL

I have this error :

    ERROR 1044 (42000) at line 16: Access denied for user

The line 16 contains : CREATE FUNCTION function_name( .. )

Should I have other grants ? 

                        

Asked by 4m1nh4j1 (177 rep)

May 23, 2014, 07:51 AM
Last activity: Jan 24, 2016, 11:40 PM

"Access denied for user" error when creating a procedure

Related Questions