Funky permission issue...

From: 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

« previous php.general (#323769) next »