SELECT DATABASES does not work

Hello,

I'm trying to get a list of all databases on the MySQL server. (I'm working on a maintanence script.)

However, I've tried several things to execute "SHOW DATABASES". With PHPMyAdmin, this query works, and returns the databases available.

With ezSQL I first connect to mysql as root (and select a database used for my project).

Then I tried these:

* $db->get_results('SHOW DATABASES'); // 0 rows returned
* $db->get_col('SHOW DATABASES', 0) (in a foreach loop) // 0 rows returned

Here's the debug output:

Query [1] -- [SHOW DATABASES]
Query Result..
No Results

Any pointers in how to get this working? I'm using ezSQL 2 and MySQL 5 (not that this should matter.)

Thanks for any help!