MySQL v8.x is Not Supported By the Edge Encryption Proxy - Errors At Proxy Startup - Support and Troubleshooting

MySQL v8.x is Not Supported By the Edge Encryption Proxy - Errors At Proxy Startup Issue  Edge Encryption Proxy does not support MySQL version 8 You have decided to configure your Edge Encryption Proxies to use a MySQL database that is running on version 8.x.

When starting the proxy the following may be seen in the edgeencryption.log file:

If you installed the MySQL database to use the stronger authentication method the Edge Encryption database user will not be able to login. To resolve this you can install the database using the older backward compatible authentication method or execute this for the Edge Encryption database user from the database command line: ALTER USER 'edge_db_user’@'%' IDENTIFIED WITH mysql_native_password BY 'mypassword'; The following will print in the log: 2018-05-25 17:32:22,722 ERROR Unable to connect to database: jdbc:mysql://localhost as user root - org.mariadb.jdbc.internal.common.QueryException: Unknown system variable 'tx_isolation' 2018-05-25 17:32:22,722 ERROR Error while accessing database

Note that other errors may be seen when using an unsupported version of MySQL database There is currently no workaround for this error. The only option is to use a MySQL database version that is supported by the Edge Proxy as documented here for your version of the edge proxy under: MySQL Database - Requirement:

Edge Encryption system requirements