mysql-readers, Thursday, May 30, 2002, 10:38:14 AM, you wrote: mr> I have a user for doing a select-to-outfile, and I've granted both the mr> file privilege and also (just for the table in question) the select mr> privilege to that user.
mr> Trying it at the command-line gives me "Access denied..." which seems mr> like it can't be the case having granted the correct privileges, no? mr> I've pasted a sample transcript below, which starts by displaying mr> exact OS version and MySQL version -- doing it all interactively while mr> I'm debugging. mr> Any ideas? Yeah, "Access denied" error means that user doesn't have necessary permissions. Can you provide some more info? i.e. full error message, how did you set up file_priv using GRANT statement or updated privilege tables manually? What version MySQL client and server do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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
