Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Did that help?
Copy link to clipboard
Copied
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)
Copy link to clipboard
Copied
Hi @defaultne3mldqroexz , It's OK.
To be clear, I am not a member of Adobe Support. I am just a ColdFusion developer like you.
Copy link to clipboard
Copied
...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)
By @defaultne3mldqroexz
Choose "MySQL" as driver.
Copy link to clipboard
Copied
Thank you, I will try
Copy link to clipboard
Copied
Hi @defaultne3mldqroexz ,
Is it working now?
Copy link to clipboard
Copied
Do you know of any issues of updating to the latest MySQL 8 connector? I'm assuming that the MySQL8 will support MySQL5 databases. Do you know if that's correct?
I saw in another post to be careful about updating:
"Since ColdFusion is using Java connectors, we can make it use the new one. Be careful! I was not able to make “old” and “new” connectors work together, so once you will switch to the new one, you will have to stop using the old one. When you try to use the new one on MySQL 5.6 or 5.7, it will cause such an error: 'Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.' So, you can switch all MySQL datasources to the new driver or stay with the old one."
https://handyman.dulare.com/connecting-coldfusion-2016-to-mysql-8/
Copy link to clipboard
Copied
I nees a cold fusion developer are you available? What is your rate?