list mysql databases using php

Question

My phpmyadmin have these databases and looks like this:

demo_db_1
information_schema
mysql
performance_schema
demo_db_2
test_db_1
test_db_2

How can I get a list of all custom databases?

Meaning: when I run a file test.php, I would like to see a list like

demo_db_1
demo_db_1
test_db_1
test_db_2

I don't want to connect to any database. Just want the list of all the created databases. How can I achieve this?

Thanks in advance

Check out this php.net/manual/en/function.mysql-list-dbs.php — Nirmal Ram
– Nirmal Ram, Commented Mar 5, 2013 at 7:44

Mostafa Shahverdy · Accepted Answer · 2013-03-05 07:51:00Z

5

Call a mysql query with mysql_query("show databases;");

You can get list of the databases you have access to with:

SHOW DATABASES;

If you want to get the list for some other user than the user you're logged in as, you have to query the mysql.db table.

edited Mar 5, 2013 at 7:51

answered Mar 5, 2013 at 7:42

Mostafa Shahverdy

2,7452 gold badges31 silver badges51 bronze badges

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

1 Comment

Mostafa Shahverdy Over a year ago

Your welcome, Just don't forget to mark this answer as correct answer ;)

Purushottam · Accepted Answer · 2013-03-05 08:30:07Z

1

You can use following code :

<?php
    //mysql_connect('HostName','UserName','Password');
    mysql_connect('localhost','root','');
    $database = mysql_query("show databases;");
    while($data = mysql_fetch_assoc($database))
    {
    $fetch[] = $data;
    }
    print "<pre>";
    print_r($fetch);
?>

answered Mar 5, 2013 at 8:30

Purushottam

84414 silver badges25 bronze badges

Collectives™ on Stack Overflow

list mysql databases using php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related