Copy link to clipboard
Copied
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?
Copy link to clipboard
Copied
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,
^ _ ^
Copy link to clipboard
Copied
Its windows server 2012/coldfusion2018/mysql8 version.
Copy link to clipboard
Copied
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,
^ _ ^
Copy link to clipboard
Copied
I think to support MySQL 8 (I did not even know there was a MySQL 8!) you'll need a MySQL driver from Oracle rather than the ones installed with ColdFusion. Also, there are all kinds of potential connection string properties that might not be supported by the default data source forms, like encryption options. I would go download the latest MySQL driver, then use "Other" in the CF administrator.
Dave Watts, Eidolon LLC
Copy link to clipboard
Copied
yogeshsurati, What is the name/version of the MySQL JAR file that you installed in ColdFusion's lib directory?
Copy link to clipboard
Copied
I did a quick Google search, and found the following:
https://dev.mysql.com/doc/refman/5.5/en/old-client.html
https://stackoverflow.com/questions/50106525/could-not-create-connection-to-database-coldfusion
HTH,
^ _ ^