Funky permission issue...
| From: | Don Wieland | Date: | Wed, 20 Aug 2014 19:14:53 +0000 |
| Subject: | Funky permission issue... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-323769@lists.php.net to get a copy of this message | ||
Got another fun one:
Trying to run this code/query from a php page:
mysql_connect('localhost', 'dwdc_pps', 'hidden') or
die(mysql_error());
mysql_select_db('dwdc_pps') or die(mysql_error());
$q = "SELECT * INTO OUTFILE \"/Macintosh HD/Users/donwieland/Desktop/data_test.csv\"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY \"\n\"
FROM snomed_db";
echo $q;
$result=mysql_query($q) OR die("Error:".mysql_error());
Generating an error: Error:Access denied for user 'dwdc_pps'@'localhost' (using
password: YES)
Basically I am trying dump a tables contents LOCALLY on my MAC. This PHP is in a sub-domain of where
the mysql database was created.
Any ideas on what my problem is and how to remedy it?
Don Wieland
D W D a t a C o n c e p t s