How to create a PHP form that assigns users MYSQL privileges and permissions

[mosmartin]

Hello fellow PHP Freaks 

 

Is there a way to assign mysql access privileges using a php script? Maybe when your registering a user and assign them a role, depending on the role, they get certain privileges on the db...

I need help.

 

Thank you in advance.

[chintansshah]

Can you please explain in detail, can you post your code, have you tried any mysql functions in php?

boss, it's very risky to give grant permission from php?

[mosmartin]

Hello  Chintansshah, I have managed to create users with privileges from MySQL but I was wondering if it's possible to do so from a web interface. E.G. have an interface with check boxes that assigns certain privileges to users as they are being registered. Or how does someone create a role and assign it privileges so that when a user is registered under that role, they automatically get the privileges assigned to that role.