Tanzu MySQL for Kubernetes connection issue

Products

• VMware Tanzu MySQL

Issue/Introduction

Tanzu MySQL for Kubernetes is configured to require an encrypted connection for client communication. Thus, when you try to connect the MySQL instance from the client on other servers, the login failed as below:

Connections using insecure transport are prohibited while --require_secure_transport=ON

Environment

Product Version: Other

Resolution

The workaround is set parameter require_secure_transport as OFF to disable the connections encrypted requirement. You may use the below command to persist the change:

SET PERSIST require_secure_transport=OFF;

The Tanzu MySQL operator does not currently support custom database configuration provided through the MySQL yaml spec. That is a feature we are planning to implement in an upcoming release. For now, running SET PERSIST as an admin user is the only way to make persistent changes.