How to save results of query to file using mysql?

Question

I want to save the result of the query's execution into txt.
I do this query:

SELECT * FROM `users` INTO OUTFILE '/home/b/myuser/domain.xyz/public_html/first.txt' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'

But I have some error like: "Error in query (1045): Access denied for user 'myuser'@'localhost' (using password: YES)"

How I can bypass this error?
I should use these permissions(not write and not edit files), because hackers install various scripts on my site.
Please, help me.

How are you connecting to database to execute this query? Error is that you are not able to connect to database. mysql -p — ankidaemon, Aug 02 '16 at 13:13
There should not be any space between -p and your password. Check out this link for more detail: http://dev.mysql.com/doc/refman/5.7/en/connecting.html — ankidaemon, Aug 02 '16 at 13:14

score 1 · Answer 1 · answered Aug 02 '16 at 13:02

1

This is a problem with connection to database. It's not a problem with writing file...

answered Aug 02 '16 at 13:02

Dave M.

82
9

but I can do "Select * from `users`" without error, but with output in file - error with connection. Why? – Kirill KZ Aug 02 '16 at 13:12
Before doing the query, you must do the connection to the database with the user 'myuser'. Can you copy that piece of code? – Dave M. Aug 02 '16 at 14:54
Ok. Has your user "myuser" the right grants to use the schema? – Dave M. Aug 09 '16 at 10:07

score 1 · Answer 2 · answered Aug 02 '16 at 13:06

1

Try following query:

SELECT * INTO OUTFILE '/home/b/myuser/domain.xyz/public_html/first.txt'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
FROM `users`

answered Aug 02 '16 at 13:06

Ejaz47

145
1
12

How to save results of query to file using mysql?

2 Answers2