Skip to main content
J
jimm710400
New Participant
January 5, 2021
Question

MySQL JDBC Driver for Coldfusion (2021 Release)

  • January 5, 2021
  • 2 replies
  • 8678 views

Moved from an old laptop to a new Surface computer. Trying to connect my Localhost (127.0.0.1) installation on Windows 10 on the IIs server to my existing MySQL database. CF Administrator works fine, as do my CF templates (except for queries, of course). Got this message:

"The standalone MySQL JDBC driver is no longer shipped with ColdFusion.
Please download it, put it in cf_root/lib folder and restart ColdFusion."

1. Where to I get the correct MySQL JDBC driver?

2. Does is go under C:\ColdFusion2021\cfusion\lib  ?

Thanks in advance.

 

    This topic has been closed for replies.

    2 replies

    BKBK
    BKBK
    Community Expert
    January 7, 2021

    Did you try the suggestion, @jimm710400 . If so, any joy?

    J
    jimm710400Author
    New Participant
    January 9, 2021

    Thanks for the help. Definitely closer. I now know its just getting the other settings right for MySQL setup. I've done this a few times in the past, as I started with Allaire Coldfusion 4.0, but the settings are different from my existing Coldfusion 10 version on my old laptop. So do you know what the setup settings are supposed to be? What I've tried:

    Datasource Name: family

    Driver: MySQL  [the other option was MySQL (DataDirect)] 

    Clicked the Add button, then on the next screen:

    CF Datasource Name: family

    Server: 127.0.0.1

    Database: familyUS  (this is the db name in MySQL Administrator, which works fine)

    Port: 3306

    Username: admin (the default) (my laptop CFADMIN that works uses ROOT)

    Password: the password used to get into CFADMIN

     

     

     

    BKBK
    BKBK
    Community Expert
    January 22, 2021

    @jimm710400 , are you up and running?

    BKBK
    BKBK
    Community Expert
    January 5, 2021

    Steps to download and install:

    1) Go to

    https://dev.mysql.com/downloads/connector/j/

     Select Operating System: Platform Independent,

    then click on "Download" button for "Platform Independent (Architecture Independent), ZIP Archive".

    2) To download directly, click on "No thanks, just start my download". This will trigger the download of the file mysql-connector-java-8.0.22.zip.

    3) Unzip the downloaded file. Copy mysql-connector-java-8.0.22.jar to C:\ColdFusion2021\cfusion\lib

    4) Restart ColdFusion 2021

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices