Problem connecting Sqoop to MySql

Question

Hi. I am facing some issue with connecting Sqoop to MySql. I am connecting it using the following command:

$ sqoop import --connect jdbc:mysql://localhost/employees

It is getting connected to random database and not to the employees database. Please help, what am I doing wrong?

Comments

Why are you using localhost? You should give the host name.

---

Hey @Raj, I am using localhost because I am running on my local system and not on a server.

Answer 1

Perhaps, you have slightly misunderstood the method to connect it. Even if you are running it on the local system, you have to specify the hostname. When you use localhost, it doesn't connect to a database because the database is pointed by the url containing the hostname. So mention the hostname, it should work:

$ sqoop import --connect jdbc:mysql://<hostname>/employees