Error message

Having problems using this script. Even though permissions are correct, I keep getting the Access denied message.

Thanks in advance,
Steve

Let me know if you require more info...

You must establish connection with MySQL database and select database.

Look at Quick_CSV_import_example.php; these lines do it:

mysql_connect("localhost", "root", "1");
mysql_select_db("test");

Check your login and password.

Alex.

Alex, I get the same error. Does your script require that "file" privileges are granted on the MySql account?

--Adam

I also am getting the same error. The table is created, but none of the rows of data are imported.

Any work arounds?

I also am getting the same error. The table is created, but none of the rows of data are imported.

Any work arounds?

For security reasons, no one has the mysql FILE priv, which means you cannot "LOAD DATA INFILE". You can, however, use a "LOAD DATA LOCAL INFILE" statement as long as you have a mysql prompt on our system and have uploaded the data file to your account here first.

This worked for me.

Excelent, changing the sql statement worked fine for me too.

and for me to

Another possible solution is to grant the appropriate privilege (or all of them) to your user account. To do that, run this (being a root):

/* to add all privileges */

GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'%'
IDENTIFIED BY 'user_password'

or

/* to add only FILE privilege, which enables use of SELECT...INTO OUTFILE and LOAD DATA INFILE */

GRANT FILE ON *.* TO 'user_name'@'%'
IDENTIFIED BY 'user_password'

Good luck!

i am on linux hosting and i am using your wonderful script, but im having the same problem. obviously i dont have root access. is there any way i can solve this problem ?