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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
