Sqoop连接远程数据库失败,提示:“Host ‘HXRHU55NHPEZSQB‘ is not allowed to connect to this MySQL server“

    技术2022-07-12  80

    Sqoop连接远程数据库失败

    20/07/02 09:40:09 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7 20/07/02 09:40:09 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 20/07/02 09:40:10 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset. 20/07/02 09:40:10 ERROR manager.CatalogQueryManager: Failed to list databases java.sql.SQLException: null, message from server: "Host 'HXRHU55NHPEZSQB' is not allowed to connect to this MySQL server"

    解决方法: 远程访问授权

    Processed: 0.010, SQL: 9