Re: mysql command line error

2005-10-25 Thread Gleb Paharenko
Hello. Is it possible that you leave some variable blank? Your script doesn't produce any error for me: [EMAIL PROTECTED] mysql-debug-4.1.14-pc-linux-gnu-i686]$ mysql --defaults-file=my.cnf -u${DB_NAME} -p${DB_PASSWORD} -e"GRANT select, update, insert, delete ON $DBNAME.* TO [EMAIL PROTE

Re: mysql command line error

2005-10-24 Thread Dustin Krysak
I got it figured out.. of all things it was a line return. DOH! Dustin On 24-Oct-05, at 12:14 PM, Dustin Krysak wrote: Sorry - but to add to this, the command is actually in a bash script. I suspect it is the single quotes and or the "()" characters Dustin On 24-Oct-05, at 11:57 AM

RE: mysql command line error

2005-10-24 Thread Logan, David (SST - Adelaide)
Hi Dustin, If this is the actual syntax as you currently have it, the single quotes around the second occurrence of $DBPASS (in the function OLD_PASSWORD) will be causing lots of grief to bash. You are passing literally '$DBPASS' to the function rather than the value of the variable. Try using dou

Re: mysql command line error

2005-10-24 Thread SGreen
Dustin Krysak <[EMAIL PROTECTED]> wrote on 10/24/2005 03:14:02 PM: > Sorry - but to add to this, the command is actually in a bash script. > I suspect it is the single quotes and or the "()" characters > > Dustin > > > On 24-Oct-05, at 11:57 AM, Dustin Krysak wrote: > > > Hi there - I am

Re: mysql command line error

2005-10-24 Thread Dustin Krysak
Sorry - but to add to this, the command is actually in a bash script. I suspect it is the single quotes and or the "()" characters Dustin On 24-Oct-05, at 11:57 AM, Dustin Krysak wrote: Hi there - I am trying to issue the following command in a terminal window... I know my syntax is sl