question

XP Li avatar image
0 Likes"
XP Li asked Kavika F commented

Database connector to MySQL failed


Test Connection fails with the following message: SSL connection error; unknown error number,

mysql-conn.png


It failed to a remote server with the same message. So I tried a local MySQL Server via Docker, which I can connect to using MySQL Workbench without any problem.


FlexSim 22.1.2
database connectormysql
mysql-conn.png (26.9 KiB)
· 4
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

XP Li avatar image XP Li commented ·

8.0 is used for MySQL

0 Likes 0 ·
Kavika F avatar image Kavika F ♦ XP Li commented ·
Hey @XP Li, have you tried using MySQL 5.7? I also cannot connect using MySQL 8.0 to FlexSim, but I can make a localhost connection fine to the Workbench.
0 Likes 0 ·
XP Li avatar image XP Li Kavika F ♦ commented ·
@Kavika F I have yet to try 5.7, but I have a way to make it "work" - simply use ODBC. I tried and it worked - the same MySQL 8.0 server.
1 Like 1 ·
Show more comments

0 Answers