Member Avatar for ankit1122

hello;

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 because: Removed username.
  • 3 Contributors
  • 2 Replies
  • 361 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by jackstone444
Member Avatar for Isaac_4

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.

2014-10-09_170037.png 16.34 KB
Edited by Isaac_4 because: Adding information on how to accomplish goal
Member Avatar for jackstone444

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.