MySQL 8 in TDV

[Bruno Vieira]

Hi!

I using TDV 7 and I need connect it to a MySQL 8 Database, but in TDV I just have MySQL 5.1 and 5.5. It's ok create a connection using MySQL 5.5 using the driver of MySQL 8 (.jar) I get error in my connection.

[Motsu Aboshi]

Without seeing the error, it's impossible to know if it's a driver issue, or a red herring. 

 

If it really is a driver issue, and presuming the mysql 8 driver is backward compatible (or you don't use mysql 5), and can run in version of Java your TDV instance uses, you should be able to update the driver in the mysql_(version) folder of conf/adapters/system. Update it, restart, and monitor the server log for any errors on startup.

 

You could also try a custom adapter extended from one of the other mysql ones.

 

If it still doesn't work, we'll need more information in order to help.

[Ajay Mundhra 2]

You should be able to use any of the MySql adapter 5.1 or 5.5 to connect to MySql 8 database. Otherwise you can create a customer adapter using MySql 5.5 adapter as base adapter in TDV. Please use the below MySql jdbc url for connecting to MySql datasource/adapter in TDV.

mysql://:/DBNameuseSSL=false&allowPublicKeyRetrieval=true

You can edit the JDBC connection url using the advanced settings panel for the datasource.