Re: mysql command line execution

[Eugene Kosov]

Ehrwin Mina wrote:
>> That isn't true. If you make a ps, you will see something like "mysql 
>> -p x xxxxxxxx ................".
>>
>> As I said before, you can use something like:
>> "mysql -uUser --password=`cat password_file` db"
>>
> 
> FYI,
> 
> Nuno is correct you cannot see the password in the 'ps' and my scripts 
> is just an example you can modify it for more security like putting it a 
> config file or much better if you can use perl. Don't forget the user 
> privileges only.
> 

Hm... May be it's OS (or MySQL version) depending stuff but following shows me you're
wrong.

1)
 > uname -r -s
FreeBSD 5.3-RELEASE

 > mysql --version
mysql  Ver 14.7 Distrib 4.1.6-gamma-nightly-20041014, for unknown-freebsd5.3 (i386)

 > mysql -ptest -utest &
 > ps | grep mysql
63841  p5  T      0:00,02 mysql -ptest -utest

2)
 > uname -r -s
SunOS 5.9

 > mysql --version
mysql  Ver 14.11 Distrib 5.0.9-beta, for pc-solaris2.9 (i386) using readline 5.0

 > mysql -ptest -utest &
 > ps -ef | grep mysql | grep test
     kea 22646 22644  0 15:56:02 pts/4    0:00 mysql -piss_pwd -uiss_usr