MariaDB 11 (also MySQL) "CLI ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it" when connecting to MariaDB 10.4 [closed]

Question

When I try to connect to a server using MariaDB 11's mariadb/mysql cli commands, I get the error "ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it" when connecting to a mariadb 10.4 server

Tried connecting to the server using the normal host, port and password options

Answer 1

This can be solved by adding the --skip_ssl parameter.

That definitely works.

If you don't want to type --skip-ssl on the command line every time, you can instead add this to ${HOME}/.my.cnf:

[client]
skip-ssl = true