Re: Listing available MYSQL databases
Actually, it's even easier than that: put /usr/local/mysql/bin/mysql -u username -p password --execute='show databases' into tCmd put shell(tCmd) The only minor downside is to get the TRUE list, you need to clean up the result a bit (the first line just says Database and the last line is empty). So you can simply do this in one statement (indented here for clarity): put line 2 to -1 of shell(/usr/local/mysql/bin/mysql -u username -p password --execute='show databases') into tDBList Ken Ray Sons of Thunder Software, Inc. Email: k...@sonsothunder.com Web Site: http://www.sonsothunder.com/ On 5/25/10 10:42 PM, Bob Cole bobc...@earthlink.net wrote: 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 gboj...@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. jo...@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...] ___ use-revolution mailing list use-revolution@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Listing available MYSQL databases
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: [...@localhost ~]$ mysqlshow -u nrl -p Enter password:(I enter the password nrl1 here) ++ | Databases | ++ | information_schema | | lab0624| | test | ++ [...@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Listing available MYSQL databases
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. jo...@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: [...@localhost ~]$ mysqlshow -u nrl -p Enter password:(I enter the password nrl1 here) ++ | Databases | ++ | information_schema | | lab0624| | test | ++ [...@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Listing available MYSQL databases
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 gboj...@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. jo...@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...] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution