Remote database creation

[cagy]

Hi all,

I've looked through the API docs but couldn't seem to find what I'm looking for. I'm looking for a way to remotely create/delete/edit databases and database users using only the user's cPanel login username and password.

I've seen a reference to "adduserdb", but didn't see it in the API docs. Here is a sample of what I saw:

user=$cpanel_username&xmlin=".urlencode("<cpanelaction><module>Mysql</module><func>adduserdb</func><apiversion>1</apiversion><args>".$cpanel_username."_$mysql_database</args><args>".$cpanel_username."_$mysql_username</args><args>ALL</args></cpanelaction>

It would be fantastic if someone could point me in the right direction.

Thanks a lot!

Cagy

[cagy]

Alternatively, and perhaps a better solution, is it possible to create databases etc... from the command line if you ssh into the user's account?

[cPanelMatt]

There is a way to do this via CLI, using one of cPanel's cPwrap scripts, this is subject to change at any time:

/usr/local/cpanel/bin/mysqlwrap ADDDB foobar

Now, as for xml-api, this is undocumented and an API1 call:

<cpanelaction>
  <apiversion>1</apiversion>
  <module>Mysql</module>
  <func>adddb</func>
  <args>foobar</args>
</cpanelaction>

[cagy]

Great, thanks for the info. Where can I find the documentation for mysqlwrap and any other CLI utilities?

[cPanelMatt]

Unfortunately at this time I am not aware of any such documentation, although you can strace it out of cpsrvd if you are familiar with process tracing.

[rajuru]

check if it helps you anyway:
The HungryCoder » Blog Archive » cPanel database administering class