Sql

Search

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

# Check the default location of secure_file_priv
SHOW VARIABLES LIKE "secure_file_priv";

# Save the file in that location
Select ... From ... INTO OUTFILE ...

Comment

MySQL server is running with the –secure-file-priv

# MySQL server is running with the –secure-file-priv

[mysqld]
secure-file-priv = ""

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql update set
Sql :: how to find median of a column sql
Sql :: how to get alternate records from a table in sql
Sql :: connect to remote mysql server
Sql :: group functions in sql
Sql :: sql wildcards
Sql :: create table database in psql
Sql :: mysql select all table that have field names
Sql :: mysql select all columns and specific fields as
Sql :: docker mysql connection refused
Sql :: where sqlalchemy
Sql :: mysql stand for
Sql :: insert into with 3 tables
Sql :: how to add column sql
Csharp :: messagebox yes-no
Csharp :: get appdata file path c#
Csharp :: how to get a list of processes c#
Csharp :: c# getasynckeystate mouse
Csharp :: how to delete all files in a directory c#
Csharp :: how to change the color of an object in unity c#
Csharp :: unity reload scene
Csharp :: how to wait in c#
Csharp :: unity application quit
Csharp :: c# for loop backwards
Csharp :: c# wait seconds
Csharp :: unity or
Csharp :: c# unzip files
Csharp :: c# log to console
Csharp :: c# format decimal as currency
Csharp :: unity mouse wheel

Search

SQL

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

MySQL server is running with the –secure-file-priv

ADD CONTENT