SQOOP - MYSQL - Practice test instance

[#1]

I am working on HDPCD practice test instance. Can anybody let me know -

a) Is there anything I should do before issue sqoop command on AWS practice instance.

b) what is the parameter I should use for --connect jdbc:?????

[#2]

@Vidya SK

Run below command to list the tables:

sqoop list-tables --connect jdbc:mysql://<mysql-server>/database --username <username> --password <password>

[#3]

what is the value for <MySQL-server> on practice instance?

[#4]

The server name is namenode

[#5]

@Kuldeep Kulkarni

what is the value for <MySQL-server> on practice instance?

[#6]

@Vidya SK - Goto Ambari UI -> select Hive service -> you should see mysql server there -> just point your mouse arrow over the link and you should get the name of mysql server

OR

you will get it in hive-site.xml

grep -A 2 mysql /etc/hive/conf/hive-site.xml

[#7]

@Kuldeep Kulkarni

Thanks Kuldeep.

With the above grep command, I got the following:

Sqoop Command:

I am getting following error. Please suggest.

[#8]

@Vidya SK - you are getting access denied exception that means user root does not have access to mysql DB using password 'hadoop'. please check your password and try again with valid username and password

[#9]

Just reset the root password I had to reset the MySQL password to do so follow the below process.Start the DB if its down

[root@sandbox]# service mysqld start

Starting mysqld: [ OK ]

Reset the MySQL password

[root@sandbox]# mysqladmin -u root -h sandbox.hortonworks.com password 'newpassword'

[root@sandbox]# mysqladmin -u root password 'newpassword'

Try out the new password and it seems to work out well

[root@sandbox]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 6

Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select user();

After validating the successful logon retry

[#10]

@rich @Vidya SK are you still having issues with this? Can you accept best answer or provide your own solution?