The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB 10.2.10 tar ball linux_64 is not working with HAproxy

Dear Team,

I just install tarball installation of MariaDB 10.2.10 using ubuntu 16.04, everything is working perfect but while creating a haproxy_check user in MariaDB so after that I am getting an error while creating a user like "INSERT INTO mysql.user (Host,User) values ('192.168.0.33','haproxy_check');" and if am using apt-get installation so then its working file, Now the main issue that haproxy check feature is not working, suggest me what I need to do?

Answer Answered by Ian Gilfillan in this comment.

You don't specify the error, but perhaps it's Field 'ssl_cipher' doesn't have a default value. If you're going to insert directly into the table, you need to make sure that all fields are validly specified. It's far better practice to use CREATE USER and GRANT rather than editing the tables directly for creating users and granting permissions.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.