• Register
0 votes
118 views

Problem :

I get mysql error help

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

6 5 3
6,930 points

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.
9 7 4
38,600 points

Related questions

0 votes
1 answer 193 views
193 views
Problem : I am facing a strange MySQL error may be it is related to the database's read-only flag. The Web application that is using the MySQL is running on Debian 7.9. It was running well but suddenly started attempting to access the application powered website ... - SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement
asked Nov 20, 2019 peterlaw 6.9k points
0 votes
1 answer 53 views
53 views
Problem : I am very new to the Linux but want to set up my MySQL databases on the Amazon ec2 instance. I have followed some directions I found about resetting a user login pass by using a --skip-grant-tables option of the MySQL. Now I want to add my user ... HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement How can I turn above option off?
asked Jan 30 jwilliam 3.9k points
0 votes
2 answers 128 views
128 views
Problem : I am trying to load my data into mysql database using below code LOAD DATA LOCAL INFILE A.txt INTO DB LINES TERMINATED BY '|'; A topic of my question is related to response I get. I understand a local data offloading is off by default and I have to enable it using following command local-infile=1 but I do not know how to execute this command.
asked Jan 28 jwilliam 3.9k points
0 votes
1 answer 38 views
38 views
Problem: I am interested in learning MySQL. Currently I am facing the following error if I tried to add the index to my table using the MySQL Workbench: “Error Code: 2013. Lost connection to MySQL server during query.” I also noticed that above error appears only when I try to run long query. I want to know the away to increase my timeout value?
asked Jul 27 Raphael Pacheco 4.9k points
0 votes
1 answer 8 views
8 views
I need to import xlsx file into mysql database applying PHP.
asked Sep 25 Daniel Anderson 4k points