#include <mysql.h>
#include <stdio.h>
#include <stdlib.h>
#include <errno.h>


int main(void)
{
  FILE *fp;
  MYSQL *mysql= mysql_init(NULL);
  mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, NULL);

  fp= fopen("/home/georg/.my.cnf", "w");

  if (!fp)
  {
    printf("cannot create configuration file\n");
    return(-1);
  }

  fprintf(fp, "[client]\nssl-ca=/etc/mysql/cacert.pem\nssl-cert=/etc/mysql/client-cert.pem\nssl-key=/etc/mysql/client-key.pem");
  fclose(fp);

  if (!mysql_real_connect(mysql, "localhost", "root", NULL, NULL, 0, NULL, 0))
  {
    printf("Error: %s\n", mysql_error(mysql));
    mysql_close(mysql);
    return(-1);
  }
  printf("Cipher in use: %s\n", mysql_get_ssl_cipher(mysql));
  mysql_close(mysql);
  return 0;
}