PHP - Get list of databases names [duplicate]

Question

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

Dharman · Accepted Answer · 2020-01-07 21:18:25Z

16

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

edited Jan 7, 2020 at 21:18

Dharman♦

34k27 gold badges106 silver badges157 bronze badges

answered Apr 1, 2012 at 15:04

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

3702 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

James Walker Over a year ago

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

Tamik Soziev · Accepted Answer · 2012-04-01 15:02:34Z

1

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

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

answered Apr 1, 2012 at 15:02

Tamik Soziev

14.8k7 gold badges46 silver badges55 bronze badges

Comments

Peter Mortensen · Accepted Answer · 2012-09-13 20:18:57Z

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, 2012 at 20:18

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Apr 1, 2012 at 15:01

jjohn

10.3k4 gold badges23 silver badges21 bronze badges

Comments

liquorvicar · Accepted Answer · 2012-04-01 14:59:02Z

-2

The MySQL command for this is

SHOW DATABASES

See the manual for more info on the SHOW command

answered Apr 1, 2012 at 14:59

liquorvicar

6,1462 gold badges19 silver badges21 bronze badges

Comments

NewUser · Accepted Answer · 2012-04-01 15:01:33Z

-2

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

answered Apr 1, 2012 at 15:01

NewUser

13.4k40 gold badges150 silver badges242 bronze badges

Comments

Peter Mortensen · Accepted Answer · 2012-09-13 20:17:38Z

-2

Write the SQL query:

  show databases

edited Sep 13, 2012 at 20:17

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Apr 1, 2012 at 14:59

kasavbere

6,02314 gold badges52 silver badges73 bronze badges

Collectives™ on Stack Overflow

PHP - Get list of databases names [duplicate]

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

Comments

Linked

Related