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.

Command MYSQL to SHOW databases + owners ??

Discussion in 'General Discussion' started by 000, Nov 1, 2013.

  1. 000

    000 Well-Known Member

    Joined:
    Jun 3, 2008
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    Hi,

    in MySQL
    how we can show the list of
    databases and owners
    in all server ?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can run the following command if you simply want a list of all databases:

    Code:
    # mysql
    mysql> show databases;
    You will find additional information about your databases in the YAML files for the accounts in the following directory:

    Code:
    /var/cpanel/databases/
    These files will also be helpful:

    Code:
    /var/cpanel/databases/dbindex.db
    /var/cpanel/databases/users.db
    Thank you.
     
Loading...

Share This Page