MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Posted by: Peter Brawley
Date: August 24, 2020 03:35PM

> But I restarted the service and app. local_infile = ON

What are the results of ...

show local variables like 'local_infile';
show global variables like 'local_infile';
show variables like 'secure_file_priv';

Where is the server? Why do you need 'local'?



Edited 1 time(s). Last edit at 08/25/2020 01:28PM by Peter Brawley.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 23, 2020 06:50PM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Peter Brawley
August 23, 2020 07:54PM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 24, 2020 06:02AM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Peter Brawley
August 24, 2020 10:17AM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 24, 2020 10:27AM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Peter Brawley
August 24, 2020 03:35PM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 25, 2020 06:15AM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Peter Brawley
August 25, 2020 01:36PM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 25, 2020 03:12PM
Re: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
JK Heydt
August 24, 2020 05:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.