Jump to content

Show All Databases on your server. even if they have diff users.


kaliza

Recommended Posts

Im working on a database management script and i was wondering how can i get to see all the databases on my server using PHP as an interface,  the "show database"  will work only if all databases will have the same Username , password as the on i am connected to the Mysql.

 

if i run show databases and im connected with user1 it will display all the ones that user1 has priviliges to only, so what about the ones with user2?!?

 

im looking for something like how PhpMyAdmin does.  ???

but what im trying to do , is display all databases on my shared server, and the databases have 3 different users, how do i get that account that accesses all 3, with out just using 1 user for all 3?  i wanna make a script so when u load the page it list all the dbs and then u can click on the one u wanna edit or monitor

 

phpMyAdmin uses an account that has access to all of your databases. If you are not on a shared server you should be able to use the same account to do such as well.

 

just use mysql_list_dbs([$link])

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.