Error 1045 in sql while exporting file

Asked Jan 26 '16 at 18:23

Active Jan 26 '16 at 18:23

Viewed 246 times

SELECT name.id,
       name.full,
FROM   name 
INTO OUTFILE 'tmp/export.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'

When I run this query, it return error

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

What should I do to solve this problem?

Also is this part correct in above query?

INTO OUTFILE 'tmp/export.csv'

asked Jan 26 '16 at 18:23

Are you entering correct username and password? – Piotr Siekierski Jan 26 '16 at 18:27
check correct answer of link:- http://stackoverflow.com/questions/16845715/1045-access-denied-for-user-rootlocalhost-using-password-yes – Alive to die - Anant Jan 26 '16 at 18:28
where to enter username? I am on live server and already login – Jan 26 '16 at 18:28
you are doing this query using php or directly in phpmyadmin panel? – Alive to die - Anant Jan 26 '16 at 18:29
@A-2A directly in phpmyadmin panel, will it work or not? – Jan 26 '16 at 18:30

0 Answers0