Re: Funky permission issue...

On Wed, Aug 20, 2014 at 3:39 PM, Aziz Saleh <azizsaleh@gmail.com> wrote: > > > > On Wed, Aug 20, 2014 at 3:22 PM, Ashley Sheridan <ash@ashleysheridan.co.uk > > wrote: > >> >> >> On 20 August 2014 20:14:53 BST, Don Wieland <donw@dwdataconcepts.com> >> wrote: >> >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 >> >-- >> >PHP General Mailing List (http://www.php.net/) >> >To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> First, try not to use the mysql_* functions, use mysqli_* or something >> like PDO instead, they're more secure. >> >> Your problem here though looks like you have either the username or >> password wrong for your MySQL account. Are you able to connect via a >> different program, like phpMyAdmin, or sqlYog with those credentials? >> Thanks, >> Ash >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > > grant all privileges > on dwdc_pps.* > to 'dwdc_pps'@'localhost' > identified by 'YOUR_PASSWORD';> flush privileges; > > GRANT FILE ON *.* TO 'dwdc_pps'@'localhost'; > > Also you might want to use PDO or mysqli, because it is deprecated and > does not provides Prepared Statements if it is not a hard change. If your > codebase is already done and you are just modifying it then don't worry > about it (unless you have the resources to rewrite it, then you should). > Forgot to mention, borrowed the answer from this link: http://stackoverflow.com/a/6091447