phpmyadmin Question posted in
The official documentation can be found here.

Cannot execute a stored procedure from phpMyAdmin

I’m trying to create stored procedures for my teammates who are non-technical and can’t write MySQL queries on their own.

They are currently accessing the database through phpMyAdmin.

However, when I create stored procedures, my teammates are unable to execute them from phpMyAdmin. They see the procedures, but the "execute" command is absent and everything else is grayed out. Here’s an example with a stored procedure named get_transaction_history:

enter image description here

To be sure, I gave my teammates the permission to execute the stored procedure with the following command:

GRANT EXECUTE ON PROCEDURE database.get_transaction_history TO 'teammate1'@'localhost';

And indeed, it’s possible for them to execute the stored procedure through the CALL command. However, phpMyAdmin won’t allow them to execute the stored procedure from its GUI. Yet, it claims that my teammates do have the EXECUTE option granted to them.

enter image description here

Anyone knows what’s going on?

Tags:

2

Answers


  1. 0

    There are separate user privileges within phpMyAdmin to the DB itself.

    Go to the phpMyAdmin homepage and click Privileges and check that the users have the privileges required to execute the stored procedure.

    Login or Signup to reply.
  2. 0

    You are most probably facing this bug https://github.com/phpmyadmin/phpmyadmin/issues/14430

    It was fixed in phpmyadmin version 5.10

    Solution: check your version and upgrade.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search