Listing available MYSQL databases

Joe F. joef1 at mac.com
Tue May 25 13:32:15 EDT 2010


This script would make promysql evaluate to "mysqlshow - u  nrl -pnrl1"

On May 23, 2010, at 3:36 PM, Glen Bojsza wrote:

> 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
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the Use-livecode mailing list