In a new installation of Gx15 u10 when trying to connect to a Database MySQL 8.0.12 shows the error of the capture:
MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
However, I can create or access a DB with that user directly from Workbench.
MySQL 8 supports a new type of authentication, which requires a new connection driver:
If MySQL is installed with this new method, it is necessary to use the Driver mysql-connector-java-8.0.11.jar, since at the moment of creating the tables, the error occurs:
Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
In addition to using the new driver, it is necessary to configure the property "MySQL version = 5.7.7 or higher", at the DataStore level.
In execution, if the driver is not updated the error is:
HTTP Status 500 - com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance (Constructor.java:408)
To connect to 'MySQL 8' (which currently only works with Java)
You have to replace the default driver with mysql-connector-java-8.0.11.jar and copy it to the model folder:
JavaModel \ web \ drivers
In the DataStore set
Use custom JDBC URL = True
Custom JDBC URL = & useSSL = false & skip-ssl