Want to create a mysql user who can create new databases,users

moustafa.egypt

• May 16, 2020 18:15

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.

• 

  GOT

  • May 18, 2020 14:03

  You'll want to use the cPanel UAPI for these types of things. You can create users, databases, etc. Example

  0
• 

  cPanelLauren

  • May 19, 2020 15:42

  Thanks @GOT!

  0

Please sign in to leave a comment.