org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory

运行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的话就不会出错。

完成！