Re: Loading CSV Data with commas
In MySQLWorkbench (8.0.20) - Options File > Security (tab) > Security (section)
the value set in my.cnf contains secure-file-priv (with dashes).
I used terminal.app nano to manually edit /etc/my.cnf to contain:
[mysqld]
secure_file_priv = /mysqlfiles
I stopped and started MySQL
In terminal I login to mysql as root
I run the command - select @@secure_file_priv;
The result returned is NULL
Something strange is going on...
BTW - I appreciate your input and truly value your knowledge and patience.
Jim P.
Subject
Written By
Posted
Re: Loading CSV Data with commas
May 31, 2021 07:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.