On Wed, Apr 21, 2010 at 02:27:47PM +0530, Siju George wrote: > On Wed, Apr 21, 2010 at 2:16 PM, Mart Frauenlob > <[email protected]> wrote: > > > > how about: > > ... -p 'my$qlPW' -N ... > > > > # `mysql -u root -p 'my$qlPW' -N -B -e 'show databases'` > Enter password: > > asks for PW > > # `mysql -u root -p'my$qlPW' -N -B -e 'show databases'` > -bash: information_schema: command not found
You got the output of 'show databases'. You then consider it a shell command and try to excute it. Why would you want to do that? What do you want to do with that output? BTW: I would suggest that you actually use a .my.cnf to hold the password, otherwise the password is available in e.g. the output of 'ps auxww' -- Tzafrir Cohen | [email protected] | VIM is http://tzafrir.org.il | | a Mutt's [email protected] | | best [email protected] | | friend -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected] Archive: http://lists.debian.org/[email protected]
