Database permission for multiple users?

[conductexam]

Hello,

I have created 18 users and 5 groups in phpmyadmin for multiple projects management.

In that case, I want to grant add, delete, edit permission to only specified users in any particular project.

But in one project, I can not able to set edit routines permission for multiple users.

Ex.
If I give edit routines permission to User-1 and then again If I give same permission to User-2.
After that User-1 will not have edit routines permission as it was transferred to User-2.

Please guide me : How to set Edit Routine permission to Multiple Users.

Thanking you in advance.

 

[cPanelLauren]

Hello @conductexam

Where are you editing the MySQL user permissions? This is best done at cPanel>>Databases>>MySQL Databases. You can click on the user/s assigned to each database and modify their permissions. You would specifically want to select "Alter Routine" for the context of this question.

Thanks!