Not able to Connect NIFI to mysql through windows

Hi @san_re 

The first error message you included is likely the result of not enabling connection over the network (or locally, as the case may be) to the Mysql server. You have to take some administrative action on a newly-installed Mysql server in order to allow outside applications (in this case, that would be the local NiFi) to connect to the server. It's difficult to troubleshoot that remotely because it could be something else, but in my experience that is the most common root cause.

This error message:

Driver class com.mysql.jdbc.driver is not found - Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.driver: Driver class com.mysql.jdbc.driver is not found

Typically means that the JDBC driver is not being found on the relevant CLASSPATH, which is in this case is NiFi. After you ensure you haven't mistyped the name of the java Driver class, you need to make sure you installed the appropriate .jar file in the location where NiFi is expecting to find it, and that the file is not corrupted, etc.

Hello @ask_bill_brooks 

I have tried to enable the connection in windows by making few modificationsin mysql,

I have tried almost all the things in the internet like adding bind-address in my.ini file.
but facing the same error again.

HI @ask_bill_brooks ,

In Mac i have tried few methods and I am facing a new issue now similar to the windows error cannot create poolable connection, attached image for your reference