Results 1 to 3 of 3
Thread: Showing databases
Aug 28, 2002, 11:28 #1
Using MySQL I want to be able to list all the databases the user has access to. mysql_list_dbs() works perfectly on my comp with a root account. On my webhost with a limited account it did not work at all. I though about running SHOW DATABASES, but that will show all databases on the server, not just the ones the user has access to
Sep 17, 2002, 14:26 #2
look at: SELECT * FROM mysql.db WHERE User = "WHATEVER"
This should give you a list of tables you have specific grants to view. It should work without root permissions.
Sep 18, 2002, 09:49 #3
I did try that, but I get an access denied error. Thank you though