Access Denied.

[scheols]

I tried this query:

 

<?php
    include("config.php");
    $load_data = mysql_query("LOAD DATA INFILE 'sql.txt' INTO TABLE `loadata`;") or die(mysql_error());
?>

 

sql.txt

INSERT INTO `loadata` (`text`) VALUES('example');
INSERT INTO `loadata` (`text`) VALUES('example');
INSERT INTO `loadata` (`text`) VALUES('example');
INSERT INTO `loadata` (`text`) VALUES('example');
INSERT INTO `loadata` (`text`) VALUES('example');
INSERT INTO `loadata` (`text`) VALUES('example');
INSERT INTO `loadata` (`text`) VALUES('example');
INSERT INTO `loadata` (`text`) VALUES('example');

 

I get access denied:

Access denied for user 'scheols_HIDDEN'@'localhost' (using password: YES)

 

My host said they don't restrict it so does anyone know whats up?

[frost]

Is that semicolon in the right spot?

 

 

<?php
    include("config.php");
    $load_data = mysql_query("LOAD DATA INFILE 'sql.txt' INTO TABLE `loadata`;") or die(mysql_error());
?>

 

should be

 

<?php
    include("config.php");
    $load_data = mysql_query("LOAD DATA INFILE 'sql.txt' INTO TABLE `loadata`"); or die(mysql_error());
?>

 

I think?

[jcombs_31]

you need to check your config file and make sure you are connecting correctly to your DB.