I'm creating a SAAS website, and every new account creation should have :
- a new database created for it dynamically from my php code ,
- a new mysql user created dynamically from my php code and granted with privlages over the new database.
My question is: How can I create a mysql user who have privilages to do these actions , ( create db, create users, grant privilages).
But It's important to note: I want this mysql user to not be able to show or manipulate any other database not created by him.
Note: I have a server with WHM access.
- a new database created for it dynamically from my php code ,
- a new mysql user created dynamically from my php code and granted with privlages over the new database.
My question is: How can I create a mysql user who have privilages to do these actions , ( create db, create users, grant privilages).
But It's important to note: I want this mysql user to not be able to show or manipulate any other database not created by him.
Note: I have a server with WHM access.