RE: [PHP-GENERAL] MySQL Question

I found out the problem was a MySQL permissions issue. To read or write an external file, the FILE option must be granted. This is not given with the "GRANT ALL ON" statement. However, I read that this brings up security issues specifically if MySQL runs as root. This would give the user the ability to read and write files as root, which is a bad thing. This is an easy problem to fix with PHP though. All the query does is redirect the data from a select statement to a file in /tmp. PHP could do this easily instead. Jason > -----Original Message----- > From: Ryan Adams [mailto:radams@fcs.uga.edu] > Sent: Wednesday, June 14, 2000 2:49 PM > To: Jason > Cc: php-general@lists.php.net > Subject: Re: [PHP-GENERAL] 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--- > _______________________________________________________ Site Design, Hosting, and E-Commerce at www.webpipe.net