Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

list all databases associated with a reseller !!

Discussion in 'General Discussion' started by furquan, Aug 23, 2010.

  1. furquan

    furquan Well-Known Member

    Joined:
    Jul 27, 2002
    Messages:
    461
    Likes Received:
    3
    Trophy Points:
    168
    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 !!!
     
    #1 furquan, Aug 23, 2010
  2. sirdopes

    sirdopes Well-Known Member
    PartnerNOC

    Joined:
    Sep 25, 2007
    Messages:
    141
    Likes Received:
    0
    Trophy Points:
    66
    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_.
     
    #2 sirdopes, Aug 24, 2010
  3. furquan

    furquan Well-Known Member

    Joined:
    Jul 27, 2002
    Messages:
    461
    Likes Received:
    3
    Trophy Points:
    168
    Thanks sirdopes :

    I'll have this run and will see how it goes :)
     
    #3 furquan, Aug 24, 2010
(You must log in or sign up to post here.)
Loading...
Similar Threads - list databases associated
  1. Jerald Feller

    FTP connects but Failed to retrieve directory listing

    Jerald Feller, Sep 18, 2017 at 3:14 PM, in forum: General Discussion
    Replies:
    5
    Views:
    48
    cPanelMichael
    Sep 19, 2017 at 12:14 PM
  2. Erik Knepfler

    Listen on multiple IPs for one domain?

    Erik Knepfler, Sep 15, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    1
    Views:
    65
    cPanelMichael
    Sep 18, 2017 at 6:18 PM
  3. Evgheny

    exim listening not only localhost

    Evgheny, Sep 15, 2017, in forum: E-mail Discussions
    Replies:
    2
    Views:
    52
    cPanelMichael
    Sep 18, 2017 at 6:12 PM
  4. sachinsaxena

    Sending Email from my Account and getting blacklisted

    sachinsaxena, Sep 13, 2017, in forum: E-mail Discussions
    Replies:
    2
    Views:
    68
    24x7server
    Sep 13, 2017
  5. jxmot

    BoxTrapper - Ignore, White, Black list order

    jxmot, Aug 29, 2017, in forum: E-mail Discussions
    Replies:
    4
    Views:
    108
    cPanelMichael
    Sep 18, 2017 at 12:19 PM

Share This Page