sqoop

一、解压安装

官网：https://sqoop.apache.org/

二、修改配置文件

cd /root/apps/sqoop-1.4.7.bin__hadoop-2.6.0/conf

cp sqoop-env-template.sh sqoop-env.sh

vi sqoop-env.sh

#Set path to where bin/hadoop is available
 export HADOOP_COMMON_HOME=/root/apps/hadoop-2.8.1

#Set path to where hadoop-*-core.jar is available
 export HADOOP_MAPRED_HOME=/root/apps/hadoop-2.8.1

#set the path to where bin/hbase is available
#export HBASE_HOME=

#Set the path to where bin/hive is available
 export HIVE_HOME=/root/apps/hive-1.2.1-bin

#Set the path for where zookeper config dir is
#export ZOOCFGDIR=

把 mysql-connector-java-5.1.39.jar放入sqoop的lib下面

cd /root/apps/hive-1.2.1-bin/lib

cp mysql-connector-java-5.1.39.jar /root/apps/sqoop-1.4.7.bin__hadoop-2.6.0/lib/

把 hive-exec-1.2.1.jar放入sqoop的lib下面 

cd /root/apps/hive-1.2.1-bin/lib

cp hive-exec-1.2.1.jar /root/apps/sqoop-1.4.7.bin__hadoop-2.6.0/lib/

三、workbench连接Linux的MySQL

如果连接不成功，修改mysql权限

grant all privileges  on *.* to root@'%';

mysql> grant all privileges  on *.* to root@'%';
Query OK, 0 rows affected (0.00 sec)

flush privileges;

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

解决数据库没有密码，运程默认不连接

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password=PASSWORD("grace") where user='root';      
Query OK, 7 rows affected (0.00 sec)
Rows matched: 7  Changed: 7  Warnings: 0

mysql> Ctrl-C -- exit!
Aborted
[root@hdp-3 ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 53
Server version: 5.6.44-log MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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> Ctrl-C -- exit!
Aborted
[root@hdp-3 ~]# systemctl stop mysql.service 
[root@hdp-3 ~]# systemctl start mysql.service
[root@hdp-3 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@hdp-3 ~]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor