i have taken shared hosting plan ..my sql query on phpmyadmin is

SELECT 'EMAIL','first','last' UNION select email,first,last from e where skills regexp "javapl" and deposit>=bid INTO OUTFILE '/home/user/etc/csvfiles/1412231915.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'

but it shows error

1045 - Access denied for user 'user'@'localhost' (using password: YES)

what should i do??

Edited by pritaeas: Removed username.

3 Years
Discussion Span
Last Post by jackstone444

This is likely because your user probably does not have the FILE privilege. I would be very much surprised to see a user on shared hosting that has this privilege as it's quite dangerous.

Note that phpMyAdmin has an export link at the bottom of all SQL results, just run your normal query, then download the file and upoad to wherever you need it.

Edited by Isaac_4: Adding information on how to accomplish goal

Attachments 2014-10-09_170037.png 16.34 KB

You can use the other queries.I think this query is wrong (SELECT 'EMAIL','first','last' UNION select email,first,last from e where skills regexp "javapl" ).Rearrange this query then you can get the results.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.