MySQL
Terkait perintah LOAD DATA LOCAL INFILE, edit my.cnf, tambahkan :[mysqld]
secure_file_priv=""
lalu restart mysql server.
Untuk yang menggunakan LOAD DATA INFILE, bisa membaca [2].
edit :
sudo jed /etc/apparmor.d/usr.sbin.mysqld
Tambahkan dibawah /var/lib/mysql/** rwk, :
/opt/webapps/alisjk/data** rwk,
Jika Anda menginstall AlisJK di folder : /opt/webapps/alisjk
Restart apparmor
sudo /etc/init.d/apparmor reload
Referensi
- Disable secure priv for data loading on MySQL, https://stackoverflow.com/questions/37596163/disable-secure-priv-for-data-loading-on-mysql
- LOAD DATA INFILE Error Code : 13, https://stackoverflow.com/questions/4215231/load-data-infile-error-code-13/19511472
No comments:
Post a Comment