RE: SSH tunnel MySQL traffic: BOTH remote & local?

2002-01-03 Thread Hershey, Ernie
Yeah, you could use SSH to forward local port or some other random port to the remote 3306, with something like: ssh -N -f -L :otherserverhostname:3306 jshmoe@otherserverhostname. Then to connect to the other machine via the ssh tunnel, run the client and connect to that port on

RE: Execute a file containing a sql script

2001-10-22 Thread Hershey, Ernie
or, from a shell prompt: [ernie@ns1 ernie]$ cat script.sql|mysql > -Original Message- > From: Kevin Smith [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 22, 2001 12:19 PM > To: TOMASSONI Dominique; 'MySQL_mailing_list' > Subject: Re: Execute a file containing a sql script > > > m

access to column in where but not select

2001-10-18 Thread Hershey, Ernie
Is there any way to give a database user access to use a column in a where clause but not to select the column? Ernie Hershey Software Developer, Hospitality and Travel Services Radiant Systems, Inc 3925 Brookside Parkway Alpharetta, GA 30022