Error 1290 or how to edit my.cnf in Ubuntu?

Question

MySQL

I have Ubuntu 16.04.1 and installed MySql 5.7.16.
The problem is this: I want to insert a text file located in $HOME. I use the command:
LOAD DATA LOCAL INFILE 'blabla' INTO TABLE bla;
and it gives me error 1290:
ERROR 1290 (HY000): The MySQL server is running
with the --secure-file-priv option so it cannot execute this statement.
I used:
SHOW VARIABLES LIKE 'secure_file_priv. I found the path, but I can't upload files there.
What other options are there to resolve the issue?
Thanks in advance.

Answer 1

recipe

Disable secure-file-priv. This must be removed from startup and cannot be modified dynamically. To do this check your MySQL start up parameters (depending on platform) and my.ini.