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

Hello, I wanted to export the csv file from MySQL command line. And used the guide following the article [HOW TO] Export mysql result to csv file.  All are good if there is no any issue. mysql> select * from devices where status = '2' INTO OUTFILE '/tmp/PLC_active.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';ERROR 1290 (HY000): The MySQL server is running...

[HOW TO] install Visual Studio Code in Arch Linux

I am moving Linux working environment from Ubuntu to Antergos. And I need to install Visual Studio Code for working with Git.  Also saw something on this progress that is needed for newbie. So I write down this article. Hope it can be help you faster.  This article follows step-by-step theory, so it is easy to do.  Step 1: You must download git repository  [root@cliff...

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

Hey guys, I am working with MySQL, then want to export the data to csv file.  mysql> select name,address from devices into outfile '/tmp/devices.csv' fields terminated by ',' enclosed by '"' lines terminated by '\n';ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement Oops! unlucky, it returns the error. Before me,...