[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!
[SOLVED] crond[PID]: (root) FAILED to authorize user with PAM (Permission denied)
I have disabled root login in /etc/security/access.conf and it appears the error message in /var/cron/log
crond[PID]: (root) FAILED to authorize user with PAM (Permission denied)
The fixed access.conf file looks like
#Allow root only from localhost and cron daemon
+ : root : 127.0.0.1 ::1
+ : root : cron crond :0 tty1 tty2 tty3 tty4 tty5 tty6
- : root : ALL
Enjoy!
Subscribe to:
Posts (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...
-
the best way to create new dump file from mysql database without extended inserts and locks with command > mysqldump --no-create-info ...