The MySQL server is running with the –secure-file-priv option so it cannot execute this statement

Question: How to solve “The MySQL server is running with the –secure-file-priv option so it cannot execute this statement”

Answer:

go to mysql settings (C:\ProgramData\MySQL\MySQL Server 5.7\my.ini) and find the line related with secure file priv option then comment it out as like the following;

# Secure File Priv.
# secure-file-priv=”C:/ProgramData/MySQL/MySQL Server 5.7/Uploads”
secure-file-priv=

Advertisements

About Firat Karakusoglu

IIT Tech.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: