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

Blacklisting IP's in Host Access Control blocks FTP connections?

Account Not Displayed in List Accounts

Could not retrieve mirrorlist error

Advice on the use of a blocklist within CSF

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

Blacklisting IP's in Host Access Control blocks FTP connections?

Account Not Displayed in List Accounts

Could not retrieve mirrorlist error

Advice on the use of a blocklist within CSF

Share This Page

sirdopes Well-Known Member
PartnerNOC