[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.
-
Question Say that I have LINQ query such as: var authors = from x in authorsList where x.firstname == "Bob" ...
-
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...
-
You can use the generic_ stubs from notepad++ source, but you may prefer the "fully portable" _TCHAR macros. These macros are all ...
1 comment:
Great read, thanks for sharing this
Post a Comment