Hello Edwin, Ehrwin,
$ mysql --version
mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)
I tried it several times, and the password always appears to me in like
$ ps -ef | grep mysql
mysql -u user -px xxxxxxx database
When I write the password interactively, no replaced password appears:
$ ps -ef | grep mysql
mysql -u user -p database
The difference could be the version of the client (probably not the server).
Edwin Cruz wrote:
Mhm....
daemon2# uname -r -s
FreeBSD 5.2.1-RELEASE
daemon2# mysql --version
mysql Ver 14.10 Distrib 5.0.6-beta, for unknown-freebsd5.2.1 (i386) using
EditLine wrapper
daemon2# mysql -utr8 -ptr8 &
daemon2# ps -ef | grep mysql
230 p0- IL 0:00.01 /bin/sh /usr/local/bin/mysqld_safe
--datadir=/var/lib/mysql
41064 p0 IL+ 0:00.02 mysql -h157.87.200.57 -utr8 -ptr8
daemon2# mysql -utr8 -p &
Enter password:
daemon2# ps -ef | grep mysql
230 p0- IL 0:00.01 /bin/sh /usr/local/bin/mysqld_safe
--datadir=/var/lib/mysql
41079 p0 SL+ 0:00.02 mysql -h157.87.200.57 -utr8 -p
I can see my pwd if I do a "ps"
-----Original Message-----
From: Eugene Kosov [mailto:[EMAIL PROTECTED]
Sent: Monday, August 01, 2005 7:03 AM
To: Ehrwin Mina
Cc: Nuno Pereira; mysql@lists.mysql.com
Subject: Re: mysql command line execution
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
--
Nuno Pereira
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]