Problem description: This error occurs when importing data:
Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
Solutions:
Find the my.ini file in the MySQL installation path,
It is generally C disk or D disk, depending on your own installation, my as follows 🙂
D: \ ProgramData/MySQL/MySQL Server 5.7 \ my ini
Find the string “secure_file_priv” and set it to have no value:
secure_file_priv=
To explain,
Secure_file_priv null means that the mySQLD restriction does not allow imports or exports.
secure_file_priv is C:\temp, which restricts mysqld to import and export in the C:\temp directory and not to other directories. When
secure_file_priv has no value, it means that it can be imported or exported from any directory.
Â
Then restart the MySQL service as follows:
Type “Services.MSC” into the taskbar search box, find MySQL, and restart it. OK.
Â
Â
Â
Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
Solutions:
Find the my.ini file in the MySQL installation path,
It is generally C disk or D disk, depending on your own installation, my as follows 🙂
D: \ ProgramData/MySQL/MySQL Server 5.7 \ my ini
Find the string “secure_file_priv” and set it to have no value:
secure_file_priv=
To explain,
Secure_file_priv null means that the mySQLD restriction does not allow imports or exports.
secure_file_priv is C:\temp, which restricts mysqld to import and export in the C:\temp directory and not to other directories. When
secure_file_priv has no value, it means that it can be imported or exported from any directory.
Â
Then restart the MySQL service as follows:
Type “Services.MSC” into the taskbar search box, find MySQL, and restart it. OK.
Â
Â
Â
Read More:
- When MySQL is running, the server suddenly goes down, which causes Mysql to be unable to restart
- The server just without updating PID file and can’t connect to local MySQL server through socket are solved
- The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
- MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
- MySQL restart error the server quit without updating PID file
- It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
- MySQL server PID file could not be found!
- Error = 2, no such file or director is prompted in the lower left corner of the MAC pycharm running file
- An error is reported when the jeecg boot project connects to the MySQL database running on docker
- (error when importing database): MySQL 2006-mysql server has gone away
- IOS WebView failed to load the web page. Error domain = kcferrodomaincfnetwork code = 310 “there was a problem communicating with the secure web proxy server (HTTPS). “
- Syntax error near unexpected token ‘$’Do is reported when running bash file
- Failed to load Main-Class manifest attribute from when the jar file is running
- Host is not allowed to connect to this MySQL server
- Import / export. SQL file / gzip file for MySQL under Linux
- MySQL Workbench: Error Code: 2013. Lost connection to MySQL server during query solution
- MySQL error set: failed to start mysql.service : Unit mysql.service is masked.
- MySQL installation failed: dpkg: error processing package MySQL server (- – configure): dependency problem
- When jar file is running: Failed to load Main-Class manifest attribute from ……Solution
- MYSQL login error: mysqladmin: connect to server at’localhost’ failed