[MariaDB discuss] Re: mariadb connector/c client not using SSL

However, a program of mine which uses mysql_real_connect() fails, reporting “Access denied for user ‘foo’@’ip’ (using password: YES)”. This is, I assume, because the user on the database side requires ssl, and my client is not using ssl.

looks to me you are missing a grant or so grant select on foo.* to foouser ... flush privileges;