How to get the list of MySQL databases used by an account/domain?

[rnjoseph]

Hi,

I need some assistance in getting the list of MySQL databases being used for a particular user account / domain via cpanel API. I have searched for a way to get the list, but no luck so far.

Does anyone know how to get the list of MySQL databases used for an account? Not all the MySQL databases, but those attached to a particular account alone.

I expected the MySQL databases names in the output for the following API function:
DomainUserData < AllDocumentation/AutomationIntegration < TWiki

But they were absent!

Hope someone will help me on this.

Many thanks in advance,
RN Joseph.

[cPanelDavidN]

Hello,

I think you're looking for MysqlFE::listdbs . If you're using it in a cPanel page, take a look at this doc for how to make frontend API2 calls. If you're making the call remotely, look at this doc about invoking API1 and API2 calls via the XML-API. And finally, if you're making a remote call with PHP, you can use the api2_query() method in the XML-API PHP client class.

If you need any help invoking that call or have any other questions, let me know!

Best Regards,
-DavidN

[rnjoseph]

Exactly, that is what I want. I will try that. If I have any more queries, I will get back to you. Thank you very much.

RN Joseph.