[SOLVED] ERROR 1290 (HY000) The MySQL server is running with the --secure-file-priv
if appears the error
ERROR 1290 (HY000) The MySQL server is running with the --secure-file-priv
you have to check
1. execute show variables and find secure_file_priv variable value (e.g. c:/uploads/)
2. use full path in SELECT .. INTO OUTFILE or LOAD DATA statements (e.g. 'c:/uploads/some_file.cvs')
3. grant file priviledge to the user (e.g. GRANT FILE ON *.* TO 'someuser'@'localhost';)
You can always change the path in my.ini file, search for secure_file_priv
Enjoy!
Subscribe to:
Post Comments (Atom)
HOWTO: Repair Logitech M325 Mouse
FixIt says that you will find single screw under CE label. It isn't always true.
-
I would like to execute mysqldump using .mylogin.cnf file and --login-path option to make it more secure as it can be with plain text passwo...
-
If your worry about data left on dedicated/hosted root server and want to remove secure all files and bits, you can clean complete disk sli... -
OUT - OF - DATE Obsolete. Please check new post ! If you have issue with Function List plugin for Notepad++ 5.1 or later, please ch...
1 comment:
Great read, thanks for sharing this
Post a Comment