LMSouq
database Open

How should I resolve --secure-file-priv in MySQL?

M0
m0bi5
1 month ago
3 views
Problem Description
I am learning MySQL and tried using a `LOAD DATA` clause. When I used it as below: ```mysql LOAD DATA INFILE "text.txt" INTO table mytable; ``` I got the following error: > The MySQL server is running with the --secure-file-priv option so it cannot execute this statement How do I tackle this error? I have checked another question on the same error message at: * [Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement](https://stackoverflow.com/questions/31951468/error-code-1290-the-mysql-server-is-running-with-the-secure-file-priv-option) but still can’t find a solution. I am using MySQL 5.6

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base