PHP - Get list of databases names

Question

How can I get a list of all the MySQL databases that exist on a server using PHP?

score 16 · Accepted Answer · edited Jan 07 '20 at 21:18

16

$result = mysqli_query($db_conn,"SHOW DATABASES"); 
while ($row = mysqli_fetch_array($result)) { 
    echo $row[0]."<br>"; 
}

edited Jan 07 '20 at 21:18

Dharman

26,923
21
73
125

answered Apr 01 '12 at 15:04

Сергей Студеникин

370
2
8

1

^^ thumbs up. for mysqli.. `$result = mysqli_query($db_conn,"SHOW DATABASES"); while ($row = mysqli_fetch_array($result)) { echo $row[0]."
"; }` – James Walker Jan 28 '18 at 21:40

score 1 · Answer 2 · answered Apr 01 '12 at 15:02

1

$dbcnx = mysql_connect ($dbhost, $dbusername, $dbpassword); 
$result = @mysql_query('SHOW DATABASES'); 

while ($row = mysql_fetch_array($result)) { 
 print_r ($row)
}

answered Apr 01 '12 at 15:02

Tamik Soziev

13,578
5
40
54

score 0 · Answer 3 · edited Sep 13 '12 at 20:18

0

At the MySQL prompt, SHOW DATABASES does what you want.

You can run this command as a query from PDO or the native PHP MySQL library and read the returned rows. Pretend it is a normal select.

You will only see the databases that the account used to connected to MySQL can see.

edited Sep 13 '12 at 20:18

Peter Mortensen

30,030
21
100
124

answered Apr 01 '12 at 15:01

jjohn

9,130
4
22
21

score -2 · Answer 4 · answered Apr 01 '12 at 14:59

-2

The MySQL command for this is

SHOW DATABASES

See the manual for more info on the SHOW command

answered Apr 01 '12 at 14:59

liquorvicar

5,903
1
14
20

score -2 · Answer 5 · edited Sep 13 '12 at 20:17

-2

Write the SQL query:

  show databases

edited Sep 13 '12 at 20:17

Peter Mortensen

30,030
21
100
124

answered Apr 01 '12 at 14:59

kasavbere

5,721
10
48
72

score -2 · Answer 6 · answered Apr 01 '12 at 15:01

-2

Just use SHOW DATABASES.It will show all the databases present in your MySQL.

answered Apr 01 '12 at 15:01

NewUser

12,175
36
139
230

PHP - Get list of databases names

6 Answers6

Linked