On Tuesday 25 February 2003 15:50, g gnanaraj wrote: > Thanks but I'm not getting the expected result. See the following: > > [quote] > [EMAIL PROTECTED] godson]$ cat chk5.sh > mysql -e "select * from baa into outfile \"/home/godson/run.sh\";" test > [EMAIL PROTECTED] godson]$ ./chk5.sh > ERROR 1045 at line 1: Access denied for user: '@localhost' (Using password: > NO) [EMAIL PROTECTED] godson]$ > [/quote] > > Any ideas ?
You must have FILE privilege to use SELECT ... INTO OUTFILE. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
