在用sqoop将MySQL的数据导入到hive中的时候出现的错误:
ERROR manager.SqlManager: Error executing statement:
java.sql.SQLException: Access denied for user 'root'@'mini1' (using password: YES)
java.sql.SQLException: Access denied for user 'root'@'mini1' (using password: YES)
这个问题是权限的问题导致的:
然后你需要加上权限:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456'
这样就可以访问了