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 trying to issue the following command in a terminal > > window... I know my syntax is slightly off, however I can not see > > what... it seems to be due to the OLD_PASSWORD function... any > > pointers? > > > > > > > > mysql -u${DB_NAME} -p${DB_PASSWORD} -e"GRANT select, update, > > insert, delete ON $DBNAME.* TO [EMAIL PROTECTED] IDENTIFIED BY > > \"$DBPASS\";SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD > > ('$DBPASS');flush privileges;" > > > > Dustin > >
What's the actual error you are getting? Can you somehow view the string you are sending to the server? I don't know BASH at all or I could suggest something to let you see it. You may need to add more single quotes around [EMAIL PROTECTED] As I said, without knowing the precise error message or knowing what your final string would look like, I am just shooting in the dark. Shawn Green Database Administrator Unimin Corporation - Spruce Pine