Re: CSV to MySQL 8 issues

[Jim Sawyer]

I've uninstalled and installed MySQL 8.013 four times. I've

Opened wwindows services
Double clicked on MySQL80
Gone to Service Status and clicked stop
I've entered --local-infile = 1
Ive then clicked Start in Service Statu;s
I've Opened the MySQL command prompt and
Logged in
I've set
SET GLOBAL local_infile = ON;

in my.ini it was originally set with
secure-file-priv = 'C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\'

I've left it that way. When I

show global variables like 'secure_file_priv'

it lists the folder sequence shown above

when I

show global variables like 'local_infile'

it shows ON.

when, from the folder containing mysqld.exe, I enter

mysqld --no-defaults --verbose --help

if shows

secure_file_priv NULL

And I STILL can't use

load data local infile...

It shouldn't be this damn hard!

Jim Sawyer