Listing available MYSQL databases

[Glen Bojsza]

Hello,

Has anyone successfully used either "open process" or "get shell()" to list
the databases available on a machine.

>From the command line I do the following and get the results I am looking
for:

[nrl at localhost ~]$ mysqlshow -u nrl -p
Enter password:                                            (I enter the
password nrl1 here)
+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| lab0624            |
| test               |
+--------------------+
[nrl at localhost ~]$

My script is as follows:
on mouseUp
   put "mysqlshow - u  nrl -p" into promysql
   put "nrl1" after promysql
   get shell(promysql)
   put it
   write "quit" to process promysql
   close process promysql
end mouseUp

The resulting message is:

mysqlshow: Access denied for user 'nrl'@'%' to database '-'

I am currently logged in as nrl in the Fedora 11 system and running Rev
under that user name.

open process lead to the same results?

thanks,

Glen