Where do you see that?

I didn't type the command to execute the mysql client, and "database" is not the password, is the default database of the session. So, in the command

mysql -u user -p database

the user is user, the password is prompted interactively, and the default database is database. The command

mysql -u user -px xxxxxxx database

was not typed by me, I typed something like

mysql -u user -ppassword database

The difference to the above is that the password is in the command, and is password.

Also, in the command that I said that I use to use in my scripts, the password is "typed" with no space between password and the argument -p, like

mysql -u user -p`cat password_file` database

(It is a *nix systems only feature, at least in Linux)

Next time send to the list, also.

Dan Tappin wrote:
You need to remove the space between -p and the password.

Example:

My user:pass is root:foobar

So my command would be:

mysql -u root -pfoobar

NOT

mysql -u root -p foobar

Dan

On Aug 1, 2005, at 9:09 AM, Nuno Pereira wrote:

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


--
Nuno Pereira

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to