Skip to main content
Participant
January 31, 2019
Question

Difficulty setting up datasource!

  • January 31, 2019
  • 2 replies
  • 328 views

Following error appearing!    

- Connection verification failed for data source: orga2

java.sql.SQLNonTransientConnectionException: [MySQL JDBC Driver][MySQL]Client does not support authentication protocol requested by server; consider upgrading MySQL client

The root cause was that: java.sql.SQLNonTransientConnectionException: [MySQL JDBC Driver][MySQL]Client does not support authentication protocol requested by server; consider upgrading MySQL client

Any help?

    This topic has been closed for replies.

    2 replies

    WolfShade
    Legend
    January 31, 2019
    WolfShade
    Legend
    January 31, 2019

    What OS?  What version of CF?  What version of MySQL?

    It almost sounds as if you're using an old version of CF with a new(er) version of MySQL.

    V/r,

    ^ _ ^

    Participant
    January 31, 2019

    Its windows server 2012/coldfusion2018/mysql8 version.

    WolfShade
    Legend
    February 1, 2019

    Okay, so you're using basically the most recent (or close to it) of everything.

    Even so, per the instructions of one of the links I provided, it might help if you download the latest JDBC drivers and try that.

    If that doesn't work, it sounds to me like something else is amiss.  Check the CF logs to see if there is an obvious error being reported.

    HTH,

    ^ _ ^