Learncfinaweek - Windows 10, installed CF11 and MySQL 5.7 all running OK, Sample Files OK, created DB from MySQL command line. Using CF11 Adminstrator following error message - com.mysql.jdbc4.MYSQLNon Transient Connection Exception - Could not create c

[noelj90228094]

Was in IT many years ago, then went into management and have become useless.  Have seen ColdFusion in action and would love to play with it.  Learn-in-a-week is starting to accumulate non-productive days.

ColdFusion 11 installed, MySQL 5.7 installed - all running, Sample files down and verified, Port 3306 seems OK , created database from Command line.  When using CF Administrator  get the message that connection to database server could not be created.

Any help from the community would be gratefully received

[BKBK]

ColdFusion no longer ships with the driver for MySQL. You have to download and install it.

To do so, go to the web page of MySQL Connector/J, the official JDBC driver for MySQL. Choose 'Platform Independent' and download the ZIP file mysql-connector-java-x.y.z-bin. Here x.y.z stands for the version (the current version is 5.1.37).

Unpack the ZIP file. Locate within the contents the JAR file mysql-connector-java-x.y.z-bin.jar (current version mysql-connector-java-5.1.37-bin.jar). Copy the JAR file to the lib directory of your ColdFusion installation (On Windows, this is, by default, the directory C:\ColdFusion11\cfusion\lib).

Restart ColdFusion. You're done. The installation of the driver is complete.