The MySQL Server does not support TLS required by the client

[benarent]

While testing MySQL I'm unable to connect as the logs are reporting the MySQL Server does not support TLS required by the client.

When logging into the database, it shows SSL CA paths are set but SSL and OpenSSL are disabled.

SHOW VARIABLES LIKE '%ssl%';

mysql> SHOW VARIABLES LIKE '%ssl%';
+-------------------------------------+---------------------------+
| Variable_name                       | Value                     |
+-------------------------------------+---------------------------+
| admin_ssl_ca                        |                           |
| admin_ssl_capath                    |                           |
| admin_ssl_cert                      |                           |
| admin_ssl_cipher                    |                           |
| admin_ssl_crl                       |                           |
| admin_ssl_crlpath                   |                           |
| admin_ssl_key                       |                           |
| have_openssl                        | DISABLED                  |
| have_ssl                            | DISABLED                  |
| mysqlx_ssl_ca                       |                           |
| mysqlx_ssl_capath                   |                           |
| mysqlx_ssl_cert                     |                           |
| mysqlx_ssl_cipher                   |                           |
| mysqlx_ssl_crl                      |                           |
| mysqlx_ssl_crlpath                  |                           |
| mysqlx_ssl_key                      |                           |
| performance_schema_show_processlist | OFF                       |
| ssl_ca                              | /etc/mysql/ssl/server.cas |
| ssl_capath                          |                           |
| ssl_cert                            | /etc/mysql/ssl/server.crt |
| ssl_cipher                          |                           |
| ssl_crl                             |                           |
| ssl_crlpath                         |                           |
| ssl_fips_mode                       | OFF                       |
| ssl_key                             | /etc/mysql/ssl/server.key |
+-------------------------`------------+---------------------------+

[benarent]

This is due to MySQL not being able to read the key file.

To fix this update the MySql group to read the Teleport certificates.

# replace /etc/mysql/ssl/ with the location of your Teleport certs.
chown -R mysql:mysql /etc/mysql/ssl/

[2022liuws]

ERROR 2003 (HY000): Can't connect to MySQL server on 'teleport-office.corp.yd.com' (61)

ERROR REPORT:
Original Error: *exec.ExitError exit status 1
Stack Trace:
github.com/gravitational/teleport/lib/client/db/dbcmd/error.go:56 github.com/gravitational/teleport/lib/client/db/dbcmd.ConvertCommandError
github.com/gravitational/teleport/tool/tsh/db.go:833 main.onDatabaseConnect
github.com/gravitational/teleport/tool/tsh/tsh.go:1202 main.Run
github.com/gravitational/teleport/tool/tsh/tsh.go:506 main.main
runtime/proc.go:250 runtime.main
runtime/asm_amd64.s:1598 runtime.goexit
User Message: exit status 1