mysql exception while importing csv file to mysql database

Question

i would like to import csv file in mysql database.

my query would be like the following.

query = "LOAD DATA INFILE '"+filename+"' INTO TABLE testtable FIELDS TERMINATED BY ',' (text,price)";

But i got the following error while importing file.

java.sql.SQLException: Access denied for user 'root'@'%' (using password: YES)

for full source code you can see http://www.javalobby.org/java/forums/t53674.html.

Any Help is greatly appriciated.

Thanks.

You can see javalobby.org/java/forums/t53674.html for more detail. i got same error while implementing the above link. — Hardik Patel
– Hardik Patel, Commented Aug 31, 2011 at 13:37

ajreal · Accepted Answer · 2011-08-31 13:59:19Z

2

the user you are using does not have the privileges to load data
you might also need to specify LOAD DATA LOCAL
make use user root allowed to access other than from localhost

edited Aug 31, 2011 at 13:59

answered Aug 31, 2011 at 13:50

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jancha · Accepted Answer · 2011-08-31 13:39:26Z

0

as error shows, you should double check if user-password-host-db combination is correct. this is what the error tells you.

answered Aug 31, 2011 at 13:39

jancha

4,9851 gold badge27 silver badges40 bronze badges

4 Comments

Hardik Patel Over a year ago

Thanks jancha. my username,password and databasename is absolutely correct, still i got the same error.

Hardik Patel Over a year ago

If i tried other sql statment then it's working properly. but when i fired the following query, i get the same error. query = "LOAD DATA INFILE '"+filename+"' INTO TABLE testtable FIELDS TERMINATED BY ',' (text,price)";

jancha Over a year ago

so, if you can execute other query, could be also grants issue. also, make sure that the file you are trying to load is "readable" by the user that is executing your script.

Hardik Patel Over a year ago

Thanks for your help. my issue is solved now. The problem is that i don't have privileges to load data.

bpgergo · Accepted Answer · 2011-08-31 13:40:26Z

0

Make sure you are allowed to log into the database as root and you have the correct password in your connect string (caspian)

Connection conn = db.connect("jdbc:mysql://localhost:3306/test","root","caspian");

answered Aug 31, 2011 at 13:40

bpgergo

16.1k5 gold badges48 silver badges70 bronze badges

3 Comments

Hardik Patel Over a year ago

If i tried other sql statment then it's working properly. but when i fired the following query, i get the same error. query = "LOAD DATA INFILE '"+filename+"' INTO TABLE testtable FIELDS TERMINATED BY ',' (text,price)";

bpgergo Over a year ago

That is strange. Could you post all your code, the whole exception stack and also indicate on which line the exception is thrown? thx

Hardik Patel Over a year ago

Thanks for your help. my issue is solved now. The problem is that i don't have privileges to load data.

Collectives™ on Stack Overflow

mysql exception while importing csv file to mysql database

3 Answers 3

Comments

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related