Current behaviour

An external MySQL 8.0 DB has been configured with a user as follows:

CREATE USER '3scale'@example.com' IDENTIFIED WITH 'mysql_native_password' BY 'XXXXXXXX';

GRANT ALL PRIVILEGES ON 3scale.* TO '3scale'@'example.com';

When trying to complete the installation some pods were failing and the reason was due to this error:

ActiveRecord::StatementInvalid: Mysql2::Error: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

That was resolved with the following steps:

enabled log_bin_trust_function_creators on DB

turned off forced encrypted connections

The problem is that it seems 3scale has a requirement here which is not listed in the documentation

Expected behaviour

When following the documentation to integrate an external MySQL DB all prerequisites should be listed to avoid errors like above.