运行azkaban是出现下图所示错误
出现以下提示
1,org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘root’@‘hrbu30’ (using password: YES))
2,Caused by: java.sql.SQLException: Access denied for user ‘root’@‘hrbu30’ (using password: YES)
3,ERROR [DataSourceUtils] [Azkaban] MySQL connection test failed. Please check MySQL connection health!
解决办法如下:
mysql -uroot -p123456 登陆mysql
mysql> show databases; 查看数据库
mysql> use mysql;
mysql> show tables;
mysql> select User,host,password from user;
执行命令
我的密码是123456,所以我后面写的是123456
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';
mysql> grant all privileges on *.* to 'hadoop'@'hrbu30' identified by '123456';
mysql> grant all privileges on *.* to 'root'@'hrbu30' identified by '123456';
mysql> flush privileges;
然后再查看
mysql> select User,host,password from user;
注意:我一开始将host为“localhost”修改成了“%”,可以不用修改,若是没解决问题的话可以修改,修改代码为
update user set host = '%' where user ='root';
修改完之后就完成了,在运行azkaban的话就不会出错。