Command MYSQL to SHOW databases + owners ??

000

Well-Known Member
Jun 3, 2008
222
6
68
Hi,

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

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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.