Listing available MYSQL databases

[Glen Bojsza]

HI Joe,

You are correct and this has help solve my problem.

regards,

Glen

On Tue, May 25, 2010 at 10:32 AM, Joe F. <joef1 at mac.com> wrote:

> 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
>
> _______________________________________________
> 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
>