MySQL : Mengaktifkan Load Data Local Infile

Bagaimana mengaktifkan mysqli.load_data_local_infile pada MySQL?

Cek Apakah Sudah di Enable

Untuk cek apakah fitur load data local infile sudah di ON atau belum kita bisa cek dengan cara login ke mysql console terlebih dahulu. Login ke mysql root atau mysql admin.

mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile  | OFF   | +---------------+-------+ 1 row in set (0.00 sec)

mysql> SET GLOBAL local_infile = 'ON'; Query OK, 0 rows affected (0.06 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile  | ON    | +---------------+-------+ 1 row in set (0.00 sec) 
mysql>

[MySQLi] mysqli.allow_local_infile = On 
[MySQL] mysql.allow_local_infile = On

 systemctl restart mysql