Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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

show secure-file-priv in mysql by query

SHOW VARIABLES LIKE "secure_file_priv";
Comment
PREVIOUS NEXT
Code Example
Sql :: connect to ssms with python 
Sql :: oracle sql create table from select 
Sql :: install mysql on bash 
Sql :: add primary key with auto increment sql server 
Sql :: truncate function in sql oracle 
Sql :: postgres check for foreign key 
Sql :: sqlite data types 
Sql :: postgres set column equal to another 
Sql :: how to find lowest in sql 
Sql :: mysql update column default value CURRENT_TIMESTAMP error 
Sql :: sql manhattan distance 
Sql :: mysql delete all except 
Sql :: drop table if exists test 
Sql :: add column text sql after column 
Sql :: postgresql distinct 
Sql :: oracle show procedures 
Sql :: remove user and their privileges postgres 
Sql :: select where duplicate mysql 
Sql :: mysql ip address 
Sql :: create mysql database on windows 
Sql :: mysql event last execution 
Sql :: convert varchar column to int in sql server 
Sql :: current timestamp in milliseconds mysql 
Sql :: if null mysql 
Sql :: sql query to select records entered in last 24 hours 
Sql :: how to inner join 4 tables in sql 
Sql :: oracle locked objects 
Sql :: sql escape quote 
Sql :: how to get 30 days previous date in mysql 
Sql :: sql inner join with where clause 
ADD CONTENT
Topic
Content
Source link
Name
5+4 =