While creating a haproxy_check user in MariaDB I am getting error ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value, what I need to do?
It's likely you are running mariadb with SSL enabled but don't have a cipher set. You have two options:
- start the server without SSL enabled if you don't require encrypted connections (remove the -ssl flag from the config options)
- set the
ssl_ciphervariable. See the documentation for a more complete picture.
Use the following commands on MariaDB or MySQL:
alter table user change column ssl_cipher ssl_cipher blob null ; alter table user change column x509_issuer x509_issuer blob null ; alter table user change column x509_subject x509_subject blob null ; alter table user change column authentication_string authentication_string blob null