I have tried to connect local NIFI to Local mysql, I have been getting an error on the processor "cannot create poolableconnectionfactory communications link failure nifi". JDBC Url and Driver are correct. i assume there may be an error while connecting with Mysql.
And also i have tried to Connect local NIFI in mac with local Mysql, i am facing an error while i enable the DBCP connection pool the error is mentioned in the image.
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.
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.
@san_re What documentation are you following for what you are attempting to do here? You're much better off following a specific set of instructions from the site where you are downloading Mysql and/or NiFi from.
For NiFi, the canonical instructions can be found here: