shell script import all csv file in folder to mysql

#!/bin/bash
FILES=/media/chieuvh/DATA/123p/*
password=hc
#echo $password
mysql -u root -p$password -e "truncate table 123P.log201611;"
for f in $FILES
do
#echo "Processing $f file"
#sql=" load data local infile '"$f"' into table 123P.log201611 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'  IGNORE 1 LINES (@dummy,transid,123ptransid,reqdate,@dummy,@dummy,@dummy,@dummy,@dummy,amount,@dummy,@dummy,@dummy,@dummy,@dummy) "
mysql -u root -p$password -e " load data local infile '"$f"' into table 123P.log201611 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'  IGNORE 1 LINES (@dummy,transid,123ptransid,reqdate,@dummy,@dummy,@dummy,@dummy,@dummy,amount,@dummy,@dummy,@dummy,@dummy,@dummy) "
# echo $sql
 #mysql -u root -phc -e  $sql
done

For Ubuntu, edit the file /etc/mysql/mysql.conf.d/mysqld.cnf and add the following line at the end:

secure_file_priv=""