(using password: YES)spark链接数据库密码正确链接不上报错解决

问题还原

INFO SharedState: Warehouse path is ‘file:/opt/soft/spark/sbin/spark-warehouse/’.
Exception in thread “main” java.sql.SQLException: Access denied for user ‘root’@‘hadoop1’ (using password: YES)

主要是配置远程访问的问题
把远程访问的%改成主机名即可

grant all privileges on*.*to'root'@'%' identified by '123456' with grant option ;