一、解压安装
二、修改配置文件
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. Commands end with ; or \g.
Your MySQL connection