一个sqoop 导入数据库的问题 不知道什么原因 我把权限都给了 怎么提示我权限不对

11/10/31 22:24:59 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
11/10/31 22:24:59 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
11/10/31 22:24:59 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
11/10/31 22:24:59 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
11/10/31 22:24:59 INFO tool.CodeGenTool: Beginning code generation
11/10/31 22:25:00 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `haha` AS t LIMIT 1
11/10/31 22:25:00 INFO orm.CompilationManager: HADOOP_HOME is /home/hadoop/cdh3/hadoop
11/10/31 22:25:01 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root/compile/1f30061bb6bff07527176169f7877c2c/haha.jar
11/10/31 22:25:02 INFO manager.DirectMySQLManager: Beginning mysqldump fast path import
11/10/31 22:25:02 INFO mapreduce.ImportJobBase: Beginning import of haha
11/10/31 22:25:05 INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT MIN(`id`), MAX(`id`) FROM haha
11/10/31 22:25:07 INFO mapred.JobClient: Running job: job_201110312039_0014
11/10/31 22:25:08 INFO mapred.JobClient: map 0% reduce 0%
11/10/31 22:25:17 INFO mapred.JobClient: map 50% reduce 0%
11/10/31 22:25:17 INFO mapred.JobClient: Task Id : attempt_201110312039_0014_m_000001_0, Status : FAILED
11/10/31 22:25:17 INFO mapred.JobClient: Task Id : attempt_201110312039_0014_m_000003_0, Status : FAILED
java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'root'@'192.168.166.213' (using password: YES)
at com.cloudera.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:166)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:606)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
at org.apache.hadoop.mapred.Child.main(Child.java:264)
Caused by: java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'root'@'192.168.166.213' (using password: YES)
at com.cloudera.sqoop.mapreduce.db.DBInputFormat.getConn

把运行命令贴一下呗!
(不过,你是不是执行过"grant all ....... localhost"操作呀?如果是那样的话, 你用root用户就登不上了,你换到登陆系统的那个用户名下试试。)
温馨提示:答案为网友推荐,仅供参考
第1个回答  2011-11-01
应该是访问mysql权限的问题。

相关了解……

你可能感兴趣的内容

本站内容来自于网友发表,不代表本站立场,仅表示其个人看法,不对其真实性、正确性、有效性作任何的担保
相关事宜请发邮件给我们
© 非常风气网