[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!