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 double quotes.
Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Dustin Krysak [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 October 2005 4:27 AM To: mysql@lists.mysql.com Subject: mysql command line error 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
