|
 steve speirs - 2006-03-17 01:07:30
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...
 Alexander Skakunov - 2006-04-12 10:40:44 - In reply to message 1 from steve speirs
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.
 Action - 2006-11-08 16:01:00 - In reply to message 2 from Alexander Skakunov
Alex, I get the same error. Does your script require that "file" privileges are granted on the MySql account?
--Adam
 Red Lion - 2006-11-14 15:45:11 - In reply to message 3 from Action
I also am getting the same error. The table is created, but none of the rows of data are imported.
Any work arounds?
 Red Lion - 2006-11-14 15:45:19 - In reply to message 3 from Action
I also am getting the same error. The table is created, but none of the rows of data are imported.
Any work arounds?
 Mich - 2006-11-18 16:54:31 - In reply to message 5 from Red Lion
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.
 Jaime Teran - 2007-04-09 07:40:40 - In reply to message 6 from Mich
Excelent, changing the sql statement worked fine for me too.
 Ruben - 2007-05-03 13:45:40 - In reply to message 7 from Jaime Teran
and for me to
 Alexander Skakunov - 2007-06-02 13:40:11 - In reply to message 5 from Red Lion
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!
 David Sassoon - 2009-07-17 03:41:33 - In reply to message 9 from Alexander Skakunov
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 ?
|