Creating database and setting privilege in MySql dynamically

Question

Is there a way to create a database on the online server dynamically where you can create the user and set the privilege from there it self. i tried creating a database on my cpannel dynamically using php but it shows a error message of access denied. It only shows up a option to create the database statically and allocate the rights to a particular user. this thing is to be done in PHP.

You have to provide privileges to user been used to connect to database in PHP. Grant access to that particular user. — Prabhjot Singh Kainth
– Prabhjot Singh Kainth, Commented Dec 4, 2019 at 6:41
my question is how to create the database dynamically and then set the privilege to the user already created. — Bhavin Kalal
– Bhavin Kalal, Commented Dec 4, 2019 at 6:45
You have to use MySql commands in query in PHP for creating the database and setting the privileges. — Prabhjot Singh Kainth
– Prabhjot Singh Kainth, Commented Dec 4, 2019 at 6:55
i have tried it and it is not working. Is there any example or sample code available with you? — Bhavin Kalal
– Bhavin Kalal, Commented Dec 4, 2019 at 7:08

kp85 · Accepted Answer · 2020-02-26 08:47:04Z

2

You have to use MySql commands in query in PHP for creating the database and setting the privileges.

answered Feb 26, 2020 at 8:47

kp85

4615 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Er Jagdish Patel · Accepted Answer · 2023-05-26 09:58:43Z

0

Please check out this solution for creating Database in CPANEL.

https://stackoverflow.com/a/76339678/3775083

answered May 26, 2023 at 9:58

Er Jagdish Patel

1932 silver badges8 bronze badges

Collectives™ on Stack Overflow

Creating database and setting privilege in MySql dynamically

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related