Bruce Dembecki wrote:
On Aug 1, 2005, at 4:58 AM, Nuno Pereira wrote:
Jason Pyeron wrote:
sorry, reply to error here
On Fri, 29 Jul 2005, Nuno Pereira wrote:
Michael Stassen wrote:
You can, but why are you reinventing the wheel? Option files have
already been provided for this purpo
b/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 li
nt: 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 ".
As I said before, y
-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&
Ehrwin Mina wrote:
That isn't true. If you make a ps, you will see something like "mysql
-p x ".
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 script
Jason Pyeron wrote:
sorry, reply to error here
On Fri, 29 Jul 2005, Nuno Pereira wrote:
Michael Stassen wrote:
You can, but why are you reinventing the wheel? Option files have
already been provided for this purpose. In what way is storing the
batch user password in 'password_file' bett
At 09:49 PM 7/29/2005, Nuno Pereira wrote:
Michael Stassen wrote:
Ehrwin Mina wrote:
Jeff,
You can make a shell script or a php script or a perl script by that way
you can hide the commands you need to execute.
eg.
Make a shell script (myshell.sh)
#!/bin/sh
myuser=dbuser
mypasswd=dbpass
sorry, reply to error here
On Fri, 29 Jul 2005, Nuno Pereira wrote:
Michael Stassen wrote:
You can, but why are you reinventing the wheel? Option files have already
been provided for this purpose. In what way is storing the batch user
password in 'password_file' better than than storing i
Hi!
Nuno Pereira wrote:
Michael Stassen wrote:
[[...]]
echo "unlock table " | mysql -udbuser -pdbpassword -Ddbname
-hlocalhost -P3306
The password is on the command line of the commands issued by the
script, so it can be seen with ps.
That isn't true. If you make a ps, you will see som
Michael Stassen wrote:
Nuno Pereira wrote:
Michael Stassen wrote:
Ehrwin Mina wrote:
Jeff,
You can make a shell script or a php script or a perl script by that
way you can hide the commands you need to execute.
eg.
Make a shell script (myshell.sh)
#!/bin/sh
myuser=dbuser
mypasswd=dbp
Nuno Pereira wrote:
Michael Stassen wrote:
Ehrwin Mina wrote:
Jeff,
You can make a shell script or a php script or a perl script by that
way you can hide the commands you need to execute.
eg.
Make a shell script (myshell.sh)
#!/bin/sh
myuser=dbuser
mypasswd=dbpassword
mydb=dbname
myho
Michael Stassen wrote:
Ehrwin Mina wrote:
Jeff,
You can make a shell script or a php script or a perl script by that
way you can hide the commands you need to execute.
eg.
Make a shell script (myshell.sh)
#!/bin/sh
myuser=dbuser
mypasswd=dbpassword
mydb=dbname
myhost=localhost
myport=330
Ehrwin Mina wrote:
Jeff,
You can make a shell script or a php script or a perl script by that way
you can hide the commands you need to execute.
eg.
Make a shell script (myshell.sh)
#!/bin/sh
myuser=dbuser
mypasswd=dbpassword
mydb=dbname
myhost=localhost
myport=3306
db1=mysql -u$myuser -
Jeff,
You can make a shell script or a php script or a perl script by that way
you can hide the commands you need to execute.
eg.
Make a shell script (myshell.sh)
#!/bin/sh
myuser=dbuser
mypasswd=dbpassword
mydb=dbname
myhost=localhost
myport=3306
db1=mysql -u$myuser -pmypasswd -Dmydb -h
Jeff Richards wrote:
Hi,
Is there a secure way of running mysql commands against the db from the
command line, or in some kind of secure batch mode, without making the
password totally visible? We need to procedurize things like "flush
tables with read lock", "unlock tables" etc. Is making the
You *COULD* include the information in the my.cnf file under the
[client] area, something like this:
[client]
user=bruce
password=brucesPassword
That would tell the client to use that unless something else is
disabled.
Of course that needs to be saved in plain text in a plain text file
s
16 matches
Mail list logo
