Allow a user can see stored procedures created by others users

Question

I have a MySQL database with some stored procedures. The problem is that there are two different users who created several procedures, so that just the user who created the stored procedure can see your content. Within this context, I want all the two users could see all stored procedures, in other words, those created by him and another user.

How this could be possible?

Answer 1

try:

GRANT Execute  ON `db_name`.* TO `user_1`@`localhost`;
GRANT Execute  ON `db_name`.* TO `user_2`@`localhost`;

Answer 2

To allow multiple Users access to others Stored Procs you should use the GRANT statement as follows.

GRANT EXECUTE ON PROCEDURE mydb.myproc TO 'userx'@'localhost';

You can find more details HERE