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