MySQL - SELECT INTO (SQL Error (1045): Access denied for user 'test'@'%' (using password: YES))

Question

When I try to export records using the below query, I am getting an error

SELECT ID, Name FROM Emp 
INTO OUTFILE 'C:/temp/hash.csv' 
FIELDS ENCLOSED BY '"' 
TERMINATED BY ';' 
ESCAPED BY '"' 
LINES TERMINATED BY '\r\n';

Error:

SQL Error (1045): Access denied for user 'test'@'%' (using password: YES)

I am getting same error while running the below:

GRANT FILE ON *.* TO 'test';

SHOW VARIABLES LIKE "secure_file_priv";
secure_file_priv:  /tmp/

I want to run a stored procedure to export the records through a .Net application. I am expecting the output file to be created on the windows computer. The MySQL instance is running on AWS.I think the "secure_file_priv" path is causing the issue. The same query is working in another MySQL instance that is running on windows server.

Thank you.

What operating system are you running on AWS? `C:` is a Windows pathname. — Barmar, May 10 '22 at 19:37
`INTO OUTFILE` writes to a file on the server, not the client. — Barmar, May 10 '22 at 19:40
*`secure_file_priv: /tmp/`* means that the outfile path must be `/tmp/`. — Akina, May 10 '22 at 20:21
check your database username and password. i think you pushing with wrong username and password — Faizul Islam, May 11 '22 at 08:14

score 1 · Answer 1 · answered May 11 '22 at 00:24

1

You need to out file the csv file to aws instance first, and then download it to your windows computer.

answered May 11 '22 at 00:24

dogs Cute

564
3
9

MySQL - SELECT INTO (SQL Error (1045): Access denied for user 'test'@'%' (using password: YES))

1 Answers1