Command MYSQL to SHOW databases + owners ??

000

• November 01, 2013 10:11

Hi, in MySQL how we can show the list of databases and owners in all server ?

• 

  cPanelMichael

  • November 01, 2013 15:33

  Hello :) You can run the following command if you simply want a list of all databases: # mysql mysql> show databases;
  You will find additional information about your databases in the YAML files for the accounts in the following directory: /var/cpanel/databases/
  These files will also be helpful: /var/cpanel/databases/dbindex.db /var/cpanel/databases/users.db
  Thank you.

  0

Please sign in to leave a comment.