Author Topic: Adding users to a database  (Read 6409 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Adding users to a database
« on: March 10, 2021, 08:08:13 AM »
In the same line of my previuos ticket, I need to associate an user to a database. I'm trying the corresponding way usermysql->add. The user is created but is not asociated to the database, also when that details is sent.
I can login in phpmyadmin but no database is able to use.
Thanks

Offline
*
Re: Adding users to a database
« Reply #1 on: March 12, 2021, 09:27:29 AM »
probably the easiest way is to do it from the user panel or if from admin than using phpmyadmin as root to be able to add custom permissions per user.
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.

Offline
*
Re: Adding users to a database
« Reply #2 on: March 12, 2021, 11:32:35 AM »
Hi @studio4host, no, that's not the easiest way to do it, because We have an API which should do this process from the external development. I need to create about 10 databases per day from the API and after that, you said that I need to go trhought phpmyadmin to assing those database to a new user, that's not the easier way.

In this case, the documentation of the API is telling me that I can create an User and assign it to a database from the API and is not working.

If you tell me where is located the code, I can modify the sentence and after provide you the possible solution, but i need to solve this problem as soon as possible please.

Offline
*****
Re: Adding users to a database
« Reply #3 on: March 12, 2021, 09:40:29 PM »
Hello

why do you say this doesn't work? You can place here the error that it shows you or the script you are using!

Offline
*
Re: Adding users to a database
« Reply #4 on: March 15, 2021, 02:48:32 PM »
Script:
https://ibb.co/YdVXKPP

Result in browser:
https://ibb.co/2MCM1Dz

Result in CWP:
https://ibb.co/nqpjjWy

And the user is not created in the user list.

Offline
*
Re: Adding users to a database
« Reply #5 on: March 15, 2021, 08:17:19 PM »
Hello

why do you say this doesn't work? You can place here the error that it shows you or the script you are using!

Script:
https://ibb.co/YdVXKPP

Result in browser:
https://ibb.co/2MCM1Dz

Result in CWP:
https://ibb.co/nqpjjWy

And the user is not created in the user list.