Off topic:MySQL error to export a txt file

Question

[Lila M]

Hi biostars!

I've created a database in mysql with all the genome annotation. I want to export only the gen column. To do that I've tried

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

select Symbol from annot_RECQL5HUunt into outfile 'symbol_RECQL5Unt.txt' lines terminated by '\n\r'

But I have the next error

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I've tried to solve adding

secure_file_priv=/var/lib/mysql-files/

to my.cnf, but it does not work. Any idea?

Thanks!