2021/12/01 09:26:38.610 +0800 ERROR [MySQLDataSource] [Azkaban] Failed to find write-enabled DB connection. Wait 15 seconds and retry. No.Attempt = 1 java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'linux121' (using password: YES)) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) at azkaban.db.MySQLDataSource.getConnection(MySQLDataSource.java:76) at org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:175) at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:286) at azkaban.db.DatabaseOperator.query(DatabaseOperator.java:68) at azkaban.executor.ExecutorDao.fetchExecutor(ExecutorDao.java:63) at azkaban.executor.JdbcExecutorLoader.fetchExecutor(JdbcExecutorLoader.java:272) at azkaban.execapp.AzkabanExecutorServer.insertExecutorEntryIntoDB(AzkabanExecutorServer.java:264) at azkaban.execapp.AzkabanExecutorServer.start(AzkabanExecutorServer.java:242) at azkaban.execapp.AzkabanExecutorServer.launch(AzkabanExecutorServer.java:152) at azkaban.execapp.AzkabanExecutorServer.main(AzkabanExecutorServer.java:148) Caused by: java.sql.SQLException: Access denied for user 'root'@'linux121' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)原因
Azkaban配置文件中的root用户,也就是mysql中的root用户访问权限是’localhost’
解决方案mysql中的root用户访问权限修改为’%’
update user set Host='%' where User = 'root';
flush privileges;



