Debin9 mysql8 no connect with lucee datasource

dev support
1

i have Debian 9 (stretch) , MYSQL 8 and Lucee 5.2.8.50

i can connect on linux-bash or from outer with the mysql-workbench

but when i try to set a datasource in web or server-Admin , i get:

“Could not create connection to database server. Attempted reconnect 3 times. Giving up.”

i use the Mysql-Extension on Version 8.0.11

please, can anybody help me ?

2

I found a solution: note the driverclass, the SSL and the timezone

this.datasources[“myds”] = {
class: ‘com.mysql.cj.jdbc.Driver’
, username: ‘username’
, password: “pw”
, connectionString: ‘jdbc:mysql://localhost:3306/my_database_name?useUnicode=true&characterEncoding=UTF-8&serverTimezone=CET&useSSL=false&requireSSL=false’

};