Skip to main content
Participating Frequently
May 17, 2021
Question

ColdFusion 2016 and My SQL 8

  • May 17, 2021
  • 2 replies
  • 828 views

I am using Coldfusion 2016 and Mysql 5.7 . I want upgrade to  Mysql 8,according to coldfusion document they mention it support 5.7. Can anyone suggest way to use Mysql 8 

    This topic has been closed for replies.

    2 replies

    May 21, 2021

    I nees a cold fusion developer are you available? What is your rate?

    BKBK
    Community Expert
    Community Expert
    May 17, 2021
    1. Stop ColdFusion.
    2. Open ColdFusion's /lib/ directory. Locate any Jar file of the form mysql-connector-java-*.*.*.jar, where *.*.* represents a version number, and delete it.
    3. Go to the MySQL Connector/J download site: https://dev.mysql.com/downloads/connector/j/ 
    4. In "Select Operating System:", choose the option "Platform Independent". The current version is 8.0.25.
    5. Click to download the "Platform Independent (Architecture Independent), ZIP Archive". Click on "No thanks, just start my download."
    6. Unpack the Zip file. You will find that the folder contains the file mysql-connector-java-8.0.25.jar. That is the driver you want.
    7. Copy the JAR file to the /lib/ directory of your ColdFusion installation.
    8. Restart ColdFusion.
    BKBK
    Community Expert
    Community Expert
    May 19, 2021

    Did that help? 

    Participating Frequently
    May 21, 2021

    Thank you support , I try next week . In between I need to known when the add the datasource  driver I have to select to "Others" is it? 

    My other datasource driver are Mysql 5 . It will work without changing the driver type or  I have to change to" Others ".

    (I am not familar with the driver)