Sqoop getting error while connecting to MySQL

0 votes

I am trying to import a MySQL table using Sqoop but it is not happening. When I run the following command:

sqoop import --connect jdbc:mysql://localhost/retail_db --username hduser --table order

I get the following error:

ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user 'hduser'@'localhost' (using password: NO)
Feb 7, 2019 in Big Data Hadoop by Gujan
1,389 views

1 answer to this question.

0 votes

Have you set a password for MySQL? Seems like it is password set but in your command, you have not mentioned any password. Try importing with password:

sqoop import --connect jdbc:mysql://localhost/retail_db --username --password <your password> hduser --table order

answered Feb 7, 2019 by Omkar
• 69,230 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Sqoop error while trying to connect to MySql

Please use the below command to solve ...READ MORE

answered May 22, 2019 in Big Data Hadoop by Bhagavath
2,560 views
0 votes
1 answer

Sqoop error while importing data from MySql

As the error states, the target directory ...READ MORE

answered Feb 11, 2019 in Big Data Hadoop by Omkar
• 69,230 points
2,148 views
0 votes
1 answer

Problem connecting Sqoop to MySql

Perhaps, you have slightly misunderstood the method ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Ali
2,197 views
0 votes
1 answer

Getting error message on execution of sqoop command to list database

Please use the sqoop list database syntax ...READ MORE

answered May 23, 2019 in Big Data Hadoop by Rashmi
2,085 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
10,924 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
2,453 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
108,317 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,390 points
4,547 views
0 votes
1 answer

Error while connecting to Hive using Java JDBC

Use ​org.apache.hive.jdbc.HiveDriver as your driver ...READ MORE

answered Nov 22, 2018 in Big Data Hadoop by Omkar
• 69,230 points
1,762 views
0 votes
1 answer

Sqoop import failed while importing mysql table to Hbase

There is a spelling mistake in your ...READ MORE

answered Feb 7, 2019 in Big Data Hadoop by Omkar
• 69,230 points
1,619 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP