Grant permissions in phpmyadmin

santrix

Well-Known Member
Nov 30, 2008
225
2
68
Hi,

I have a user who wants to be able to grant table specific permissions to one of the users he has set up on his DB.

Is this possible? I thought it wasn't, but the customer insists that another hosting company has made it possible in the past. I thought it was effectively the root user that granted rights by proxy from the cpanel scripts - and that the individual cpanel users accounts don't have the rights to GRANT table access?
 

santrix

Well-Known Member
Nov 30, 2008
225
2
68
OK, on further study I can see that the user table in the "mysql" database determines which mySQL accounts have GRANT privs...

Assuming a standard WHM install, if I add the GRANT priv to a mySQL user, is that going to :

1) allow them to grant any other user on the server privs to the database/s it has been given access to via the db table?

or

2) allow them to grant anyone to anything?

Obviously I want to avoid the latter! So what I'm asking is, what are the ramifications of putting a Y in the Grant_priv column for a mysql user account, assuming they have only been given access to their own DB in the db table (as per standard cpanel config) ?