Sunday, 15 July 2012

mysqli - MySQL on Ubuntu 12.04 LOCAL_INFILE still disabled -



mysqli - MySQL on Ubuntu 12.04 LOCAL_INFILE still disabled -

on ubuntu 12.04 64bit lts, including mysql version 5.5.29 - trying load info local infile command in mysql, fails with

db error (1148) used command not allowed mysql version

i have done following:

added local-infile=1 [mysql] , [mysqld] sections of /etc/mysql/my.cnf file, , restarted mysql service;

added line alternative mysqli_opt_local_infile,true mysqli initiation:

function dbconnect($dbhost, $dbuser, $dbpass, $dbname) { $mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname); $mysqli->options(mysqli_opt_local_infile,true); if ($mysqli->connect_error) die('db connect error (' . $mysqli->connect_errno . ') '. $mysqli->connect_error); homecoming $mysqli; }

but still getting error? maybe local-infile alternative has not been compiled in mysql version?

mysqli ubuntu-12.04

No comments:

Post a Comment