Re: MySQL Question

Sounds like a mysql access problem to me. How are you connecting to the db from the script? Ryan On Wed, Jun 14, 2000 at 11:38:30AM -0600, Jason wrote: > This question is more related to MySQL than PHP I think. > > I'm trying to execute the following statement from PHP: > select * into outfile '/tmp/students.csv' fields terminated by > '|' from comments; > > When I run this query as the DB owner, I get the following error: > ERROR 1045: Access denied for user: 'hoster@localhost' (Using > password: YES) > > The password is correctly specified. > > When I run the same query as the superuser "root", it executes > successfully. I've read that a user has to have FILE permission > granted which the user "hoster" has. I get the same error if I > try the statement via command line as well. Any ideas? > > Jason > > _______________________________________________________ > Site Design, Hosting, and E-Commerce at www.webpipe.net > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net ---end quoted text---