Exporting data from mysql to csv

0

I am trying to export specific data from a bank from a client to csv, I searched the internet and they said I would get using the code below.

SELECT * FROM escola
INTO OUTFILE '/var/lib/mysql-files/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

But when I use it appears: "SQL error 1045" Access denied for user 'forms' @ '%' (using password: YES). "I was searching the mysql forum itself, and found information saying that I would have to

I'm thinking of doing with python, using multiple selects and handling the data for creating csv, but I think it's an unnecessary effort.

I'm using HeidiSQL 9.5.0

    
asked by anonymous 16.02.2018 / 13:49

0 answers