连接mysql报错日志
[root@bigdata ~]# sqoop list-databases --connect jdbc:mysql://bigdata:3306 --username root --password mysql;
Warning: /software/sqoop-1.4.6/bin/../../hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
Warning: /software/sqoop-1.4.6/bin/../../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /software/sqoop-1.4.6/bin/../../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
Warning: /software/sqoop-1.4.6/bin/../../zookeeper does not exist! Accumulo imports will fail.
Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation.
17/07/29 19:57:27 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
17/07/29 19:57:27 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
17/07/29 19:57:27 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
17/07/29 19:57:27 ERROR manager.CatalogQueryManager: Failed to list databases
java.sql.SQLException: Access denied for user 'root'@'bigdata' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
检查mysql服务
[root@bigdata lib]# netstat -n | grep 3306
tcp 0 0 192.168.166.16:3306 192.168.166.1:61927 ESTABLISHED
tcp 0 0 192.168.166.16:3306 192.168.166.1:61939 ESTABLISHED
tcp 0 0 192.168.166.16:3306 192.168.166.1:61930 ESTABLISHED
[root@bigdata lib]# ps -ef | grep mysql
root 46245 46212 0 18:39 pts/1 00:00:00 mysql -u root -px xxx
root 46952 1 0 20:00 pts/4 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/bigdata.pid
mysql 47039 46952 0 20:00 pts/4 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=bigdata.err --pid-file=/var/lib/mysql/bigdata.pid
root 47212 46541 0 20:15 pts/2 00:00:00 grep mysql
[root@bigdata lib]#
检查sqoop连接mysql jar包
[root@bigdata lib]# ls -lrt
-rw-r--r--. 1 root root 996444 Jul 16 23:25 mysql-connector-java-5.1.42-bin.jar
[root@bigdata lib]# pwd
/software/sqoop-1.4.6/lib
开放mysql的远程访问权限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION; ()
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql>
检查mysql的用户表
bigdata 主机名可以连接。
重启mysql后连接正常
[root@bigdata ~]# sqoop list-databases --connect jdbc:mysql://bigdata:3306 --username root --password mysql;
Warning: /software/sqoop-1.4.6/bin/../../hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
Warning: /software/sqoop-1.4.6/bin/../../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /software/sqoop-1.4.6/bin/../../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
Warning: /software/sqoop-1.4.6/bin/../../zookeeper does not exist! Accumulo imports will fail.
Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation.
17/07/29 20:02:46 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
17/07/29 20:02:46 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
17/07/29 20:02:47 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
information_schema
mysql
performance_schema
sqoop
test