list all databases associated with a reseller !!

furquan · Aug 23, 2010

Hello All :

I have a requirement from a reseller and he needs to know all the DB's associated with all his hosted accounts. he has some 100 account and i cannot go browsing each panel for the info.

How is it possible to get it via CLI or any available script ?

Any assistance please !!!

sirdopes · Aug 24, 2010

This can easily be done in bash. I am sure there are better ways but I would use something like the following:

for i in `grep OWNER=owername /var/cpanel/users/* -l | cut -d '/' -f 5`; do ls /var/lib/mysql/ | grep $i_ ; done

That should print out a list of all of the databases assuming that you are not using the new cpanel feature where the databases do not start with the user_.

furquan · Aug 24, 2010

Thanks sirdopes :

I'll have this run and will see how it goes

Forums

The Community Forums

Interact with an entire community of cPanel & WHM users!

list all databases associated with a reseller !!

furquan Well-Known Member

sirdopes Well-Known Member PartnerNOC

furquan Well-Known Member

UAPI command to list databases

Cannot delete Mailing list issue

In Progress [CPANEL-26332] API Tokens and WHM Function list-zones

SOLVED White-list/Black-list address on SpamAssassin for entire server

ModSecurity - Domain listed not mine

Share This Page

Useful Searches

The Community Forums

Interact with an entire community of cPanel & WHM users!

list all databases associated with a reseller !!

furquan Well-Known Member

sirdopes Well-Known Member PartnerNOC

furquan Well-Known Member

UAPI command to list databases

Cannot delete Mailing list issue

In Progress [CPANEL-26332] API Tokens and WHM Function list-zones

SOLVED White-list/Black-list address on SpamAssassin for entire server

ModSecurity - Domain listed not mine

Share This Page