Listing available MYSQL databases

[Bob Cole]

If you put "SHOW DATABASES;" in a text file on the target 
machine then you can execute the following statements
(watch for line breaks):
     put "/usr/local/mysql/bin/mysql -u username -ppassword < '/usr/local/ShowDatabases.txt'" into myCommand
     put shell(myCommand) into message box
That works for me on my Mac with OS X 10.6.3
Bob


Tue, 25 May 2010 11:41:21 -0700, Glen Bojsza <gbojsza at gmail.com> wrote:
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.
[...snip...]