MYSQLI_OPT_LOCAL_INFILE

You can get MySQLi object.

When CI4 MySQLi connection does not yet connect to MySQL server.
$db     = db_connect();
$mysqli = $db->connect();
d($mysqli);      // mysqli object

When CI4 MySQLi connection has already connected to MySQL server.
$db    = db_connect();
dd($db->mysqli); // mysqli object

Following this I thought I can set the option like this:

Code:

$db->mysqli->options(MYSQLI_OPT_LOCAL_INFILE, true);

But this still gives me the error "LOAD DATA LOCAL INFILE is forbidden, check related settings like mysqli.allow_local_infile|mysqli.local_infile_directory or PDO::MYSQL_ATTR_LOCAL_INFILE|PDO::MYSQL_ATTR_LOCAL_INFILE_DIRECTORY".


How can I overcome this?