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