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, 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]