Have you tried connecting using MySQL JDBC driver? I'm saying this, because we had problems connecting to a Tibero Database using ODBC. ODBC worked for some things but not all, especially when it came to stored procedure calls.
Tibero is not supported by Appeon so we used the jdbc driver and now everything works.
I haven't tried myself with MySQL so no guarantees.
I now see you also want to connect from powerserver. If it works for powerbuilder classic, it would probably not be a solution for PowerServer as most people setup powerserver for IIS and not for JBoss, Wildfly or similar.
I did some test with version 8 and PB back in September 2018, the problem I had at that time was for some reason PB or the ODBC was looking for the table mysql.proc when a store procedure was called but that table do not exist anymore in MySQL version 8.
That why I'm asking if any special work was done on the PB side to fix this or it has nothing to do with PB and I'm missing something...
Hi Sylvain ... Update: Engineering is still hoping to add support for MySQL 8 and O18C/19C for PS 2020 GA but at this time, they are still working through some functionality issues with each of those releases.