mysql in docker secure-file-priv problems

75
October 29, 2021, at 02:40 AM

mysql in docker on windows with python, local

LOAD DATA INFILE... query gets the pymysql 1290 error, 'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement'

mysql> SHOW VARIABLES LIKE 'secure_file_priv'; in powershell shows 'NULL'

tried LOAD DATA LOCAL INFILE... as found as possible solution

get pymysql error 3948, 'Loading local data is disabled; this must be enabled on both the client and server sides'

found different solutions saying:

-'secure_file_priv' shouldn't be a path, should be NULL

-'secure_file_priv' must be empthy, (= "")

did not found how to acces mysql 'my.ini' configfile in docker to change...

does someone now a definitive solution? (i'm working only local)

READ ALSO
Can Jinja be used inside of a CSS file?

Can Jinja be used inside of a CSS file?

So I'm using Flask, Python, HTML, CSS, and jinja2 for a project and I wanna try to use jinja to make my website dynamic so I need to ask if it's possible to use jinja inside of my CSS file something like this:

84
Why am I unable to slide a Div onto the screen using jquery animate?

Why am I unable to slide a Div onto the screen using jquery animate?

I have a simple effect I am trying to achieve, but am doing something wrong

40
Recursive limit exceeded - Pyomo?

Recursive limit exceeded - Pyomo?

I'm a newcomer to Pyomo, trying to solve an LP that I've implemented

50
Where and how is SavedStateHandle data stored on disk?

Where and how is SavedStateHandle data stored on disk?

When saving part of the UI state using SavedStateHandle, the data in the state is persisted (on disk) on app process deathFor various domain/business reasons, this data might contain sensitive information

47