So, i have been tasked to integrate my app (1st app) to another app(2nd app). The 2nd app use HeidiSQL v126.96.36.19996 with MySQL as the network type (see attachment for more details). Now, I need to read the database of this 2nd app with ODBC connection. When I create a DSN, unfortunately it failed (the error says "Bad handshake"). After some research, I found out that the ODBC only works for MySQL database with version of 5.5 or higher.
My question is : How do I check the MySQL version of this 2nd app ?