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 PROTECTED] IDENTIFIED BY
\"$DBPASS \";SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD
('$DBPASS');flush privileges;"
Enter password:
[EMAIL PROTECTED] mysql-debug-4.1.14-pc-linux-gnu-i686]$
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
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
