mysql - MariaDB secure-file-priv settings -


i have huge problem setting secure-file-priv. have added correspondent option in /etc/my.cnf is:

secure-file-priv=/home/username/ 

when tried restart service won't up

log file shows this:

161108  8:49:11 [note] /usr/libexec/mysqld: normal shutdown  161108  8:49:11 [note] event scheduler: purging queue. 0 events 161108  8:49:11  innodb: starting shutdown... 161108  8:49:12  innodb: shutdown completed; log sequence number 1597945 161108  8:49:12 [note] /usr/libexec/mysqld: shutdown complete  161108 08:49:12 mysqld_safe mysqld pid file /var/run/mariadb/mariadb.pid ended 161108 08:49:13 mysqld_safe starting mysqld daemon databases /var/lib/mysql 161108  8:49:13 [warning] failed normalize argument --secure-file-priv. 161108  8:49:13 [error] aborting  161108 08:49:13 mysqld_safe mysqld pid file /var/run/mariadb/mariadb.pid ended 

when change folder path for: secure-file-priv=/home/ works fine.

i'm using mariadb 5.5.50

can guys please give me hints ?

edit: problem solved. each user folder in /home has permissions 700 changing 755 made works


Comments

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

javascript - jQuery UI Splitter/Resizable for unlimited amount of columns -

javascript - IE9 error '$'is not defined -