title: MySql error "Cannot create PoolableConnectionFactory (Could not create connection to database server.)" while connecting with azkaban?
body: <p>I am trying to connect Azkaban ( A job scheduler for hadoop) with my local mysql. The configiration file of azkaban looks like:</p>
  
  <pre><code>database.type=mysql
  mysql.port=3306
  mysql.host=localhost
  mysql.database=azkaban
  
  #Changed by Prakhar for azkaban , Azkaban
  mysql.user=root
  mysql.password= [ Password of mysql ]
  </code></pre>
  
  <p>My MySql has a database named "azkaban" and i am able to login mysql using command:</p>
  
  <pre><code>./mysql -u root -p
  </code></pre>
  
  <p>Also mysql is working on port 3306, which i have verified.
  Still i am unable to connect to mysql. The logs of azkaban looks like this:</p>
  
  <pre><code>2020/04/11 22:38:05.584 +0530 ERROR [MySQLDataSource] [Azkaban] Failed to find write-enabled DB connection. Wait 15 seconds and retry. No.Attempt = 1
  java.sql.SQLException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
      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.fetchActiveExecutors(ExecutorDao.java:53)
      at azkaban.executor.JdbcExecutorLoader.fetchActiveExecutors(JdbcExecutorLoader.java:266)
      at azkaban.executor.ExecutorManager.setupExecutors(ExecutorManager.java:223)
      at azkaban.executor.ExecutorManager.&lt;init&gt;(ExecutorManager.java:131)
      at azkaban.executor.ExecutorManager$$FastClassByGuice$$e1c1dfed.newInstance(&lt;generated&gt;)
      at com.google.inject.internal.DefaultConstructionProxyFactory$FastClassProxy.newInstance(DefaultConstructionProxyFactory.java:89)
      at com.google.inject.internal.ConstructorInjector.provision(ConstructorInjector.java:111)
      at 
  </code></pre>