Sentora Support Forums
#1290 - The MySQL server is running with the --secure-file-priv - Printable Version

+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: General Support Forum v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=36)
+---- Thread: #1290 - The MySQL server is running with the --secure-file-priv (/showthread.php?tid=1668)

#1290 - The MySQL server is running with the --secure-file-priv - txt3rob - 06-13-2015

HI Guys,

Trying to issue the following command

Code:
LOAD DATA INFILE '/var/sentora/hostdata/lairdexpertit/public_html/lairdexpertit_com/phonestats/csv/north.csv' INTO TABLE `north` FIELDS TERMINATED BY ',' ENCLOSED BY '\"' IGNORE 1 LINES


get the following error.

Code:
#1290 - The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I do need this function any fixs please?

RE: #1290 - The MySQL server is running with the --secure-file-priv - apinto - 06-13-2015

Can you use the LOAD DATA LOCAL INFILE ? Would that work for you?

RE: #1290 - The MySQL server is running with the --secure-file-priv - txt3rob - 06-15-2015

LOCAL looks as though it will work ill have to alter my script to incorporate this

RE: #1290 - The MySQL server is running with the --secure-file-priv - apinto - 06-15-2015

(06-15-2015, 06:05 PM)txt3rob Wrote: LOCAL looks as though it will work ill have to alter my script to incorporate this

You will have to either change your script or change Sentora.

Personally I would change the script as most web hosting servers are blacklisting the command for security reasons.

It's up to you Smile

RE: #1290 - The MySQL server is running with the --secure-file-priv - Me.B - 06-16-2015

secure-file privilege is security feature that MySQL need otherwise any mysql user will be able to drop files everywhere and you can then feel the pain.

Don't ever mess up with this feature.

What would preven any user in the server to do the same and grave any file in the server? That would be bad no?

M B

RE: #1290 - The MySQL server is running with the --secure-file-priv - txt3rob - 06-17-2015

my server isnt hosting any one else's data apart my own.

any way i can turn off the secure priv as it's messing with my stats import unless any one has a way to import 20 .csv's each day to a mysqldb

RE: #1290 - The MySQL server is running with the --secure-file-priv - apinto - 06-18-2015

Why you cant just edit the script?

This is not even a Sentora issue.

Also, if you are just hosting your files why use sentora? :\ I don't get it.

RE: #1290 - The MySQL server is running with the --secure-file-priv - Me.B - 06-18-2015

(06-17-2015, 10:30 PM)txt3rob Wrote: my server isnt hosting any one else's data apart my own.

any way i can turn off the secure priv as it's messing with my stats import unless any one has a way to import 20 .csv's each day to a mysqldb

In cas of a website hack. It can be used to escalate privilege easily. This is not even about you are the only user.

M B