• Register
Welcome to Kodlogs Q&A, programming questions and answer website.

Most popular tags

java python javascript android c# r mysql program spring python-3 php c x windows sql-server spring-boot numpy eclipse sockets arrays exception tomcat ggplot2 ios hibernate jquery sql string jdbc node js html python-2 ssl 7 asp list spring-mvc entity-framework keytool matlab pandas django git linux csv facebook json net java-8 intellij-idea ssl-certificate amazon-web-services reactjs unit-testing macos minecraft pip maven xcode security database class google-chrome elasticsearch tsql unity3d heap-memory for-loop scikit-learn machine-learning winforms glmnet webpack illegalstateexception postgresql redirect junit tensorflow docker ubuntu typeerror loops css cmd tcp math datetime cryptography loop int import https x11 sql-server-2012 laravel-5 pdo fatal-error struts java-applet pytorch runtime-error conda visual-studio apache-spark pyspark garbage-collection sql-server-2005 facebook-graph-api entity-framework-4 reporting-services anova keras indentation-error laravel android-studio jupyter-notebook tcplistener orm qt virtualenv webclient prediction headless visual-studio-2010 compiler-errors numpy-ndarray sudo curl vagrant aspnet reporting dataframe npm nullpointerexception javafx jsp gradle gcc jpa wordpress servlet indentation mongodb firebase scanner sum github deployment socketexception certificate util oracle recursion search syntax connection float httpwebrequest ajax excel dictionary main function number file html5 2 google-chrome-devtools sequelize utf-8 kaggle lm file-upload javascript-events net-mvc-3 google-chrome-extension payment-gateway error-handling magento paypal aws-vpc amazon-iam aws-lambda executionexception html5-canvas vmware-workstation junit5 kotlin floating-point-precision autowired lifecycleexception catalina return-value joptionpane nan dom postgresql-9 wkwebview webkit cgroups mingw xming inno-setup jasmine osx-mavericks firebase-cloud-messaging google-play-services xcodebuild facebook-login ruby-on-rails-3 pdfkit selenium-chromedriver selenium-webdriver makefile android-gradle-plugin android-ndk cross-domain xcode6 sybase jsp-tags data-files zoo web-development-server xss functional-dependencies mysql-error-1064 node-sass gulp-sass archlinux sass data-science spring-batch psycopg2 backpropagation texture2d async-await net-mvc-4 google-calendar ruby-on-rails-4 ruby-on-rails dbmigrate wp-mail github-for-windows facebook-android-sdk jsx xcb microsoft-metro react-router spring-data-jpa softmax elastic-beanstalk google-sheets-api google-spreadsheet-api cnf minidump xuggler acumatica gitlab elasticsearch-5 app-transport-security ios10 ios9 cdn cloudflare wampserver plpgsql aptitude systemd salt-stack sysv parent-child android-edittext textview visual-studio-2012 android-workmanager unique-index unity2d electron theano maven-compiler-plugin pickle assetbundle rstudio bar-chart python-tesseract tomcat6 primefaces solr easymock jvm-crash tomcat7 apache-httpclient-4 web-services woodstox discord jersey-2 prepared-statement resultset sencha-cmd sencha-touch-2 sencha-touch wkhtmltopdf powermock fips apex x509certificate ibm-bpm websphere-7 file-permissions file-io accesscontrolexception grizzly atmosphere slick2d lwjgl informetica twitter-bootstrap-3 jax-rs resteasy spring-security-kerberos spring-security kerberos long-integer mapnik git-review vpython continuation homebrew xgboost android-asynctask stack-trace user-interface jaxws-maven-plugin maven-3 maven-2 browser-notsupportedexception google-maps-api-3 google-maps visual-studio-code truststore firebase-authentication aws-organizations php-7 string-formatting cplusplus visual-studio-2015 net-core net-mvc msbuild extension-methods foreign-keys windows-services react-redux inputstream quirks-mode internet-explorer-9 internet-explorer reportingservices-2005 debian linear-regression deep-learning block-device melt reshape2 floating-point webpack-dev-server javascrip 0-lollipop android-5 statsmodels avx eclipseide javafx-2 php-not-recognized command-line putty phpmyadmin tinyurl classnotfoundexception atom-editor android-emulator android-sdk-tools ionic2 cordova foobar2k net-2 net-4 ole-db-provider export-to-excel openrowset windows-10 vagrantfile jvm-arguments global-variables sqlexception autopostback classformatexception eof upstart ipv4 graphviz pydot atom curses unityeditor pandoc tesseract xls oledb redux spotify cxf wamp nio stacked typescript hyperlink outlook jackson ssh keystore applicationcontext iis jstl encryption perfect-square objective-c carthage xcode8 indexing standard-deviation apt xampp printer connector apple cpanel mdf kubernetes destructor gettime arithmeticexception mix iphone probability ioexception heuristics milliseconds disk angular cpu code program modx-revolution goldsky modx prevnext javascript-dictionary stack-smashing device-monitor radio-button android-actionbaractivity android-activity android-fragments java-long unqualified-id ora-12154 javc c++ java nullpointerexception runtime-error drjava awt-eventqueue dsx math-pow ajquery nosuchelementexception appcompatactivity jsf jtextfield awt jpanel thymeleaf inputmismatchexception glassfish deque anaconda jupyter flask lvalue swing servlets netbeans jdk simulation ibm na factorial javax apache arduino boot opengl virtualbox jar jvm margins 2147483647 cloud plot ruby angularjs plugins automation crash card install repository odbc push installer pointers annotations merge editor concatenation swift formatting printf debugging devices module testing color arraylist sequence nested date variables caching expected build response ip pdf upload directory decimal algorithms release express collections print figure casting url expression validation integer microsoft sorting sort read logging types replace rest limit 8 4 email exe message required text 1 variable time size dll system files table runtime static random code web map http error version 0 my
0 votes

Problem :

I get mysql error help

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

by (6.9k points)  
edited ago by

1 Answer

0 votes

Solution :

I had faced similar mysql database issue in the past.
Here is what worked for me in Windows 7 to disable secure-file-priv 
  • First you must stop the MySQL server service by going into services.msc.
  • Go to path C:\ProgramData\MySQL\MySQL Server 5.6.
  • Now open the my.ini file in Notepad.
  • Please search for 'secure-file-priv'.
  • Make sure you comment the line out by adding '#' at the start of the line. 
  • For MySQL Server 5.7.16 and above, commenting won't work. 
  • You have to set it to an empty string like this one - secure-file-priv=""
  • Please save the file.
  • Now you can start the MySQL server service by going into services.msc.
by (14.4k points)