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

cPanel & WHM Version
86.0 (build 20)

moustafa.egypt

Registered
May 16, 2020
1
0
1
eGypt
cPanel Access Level
Root Administrator
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

Get Proactive!
PartnerNOC
Apr 8, 2003
1,753
311
363
Chesapeake, VA
cPanel Access Level
DataCenter Provider
  • Like
Reactions: cPanelLauren