title: mysql --ssl-verify-server-cert=true is returning "SSL certificate validation failure"
body: <p>By trying to setup Mysql over SSL on RHEL6 I'm facing an error any time I ask mysql client to verify the self-signed certs :</p>
  
  <pre><code>mysql --ssl-ca=/tmp/newcerts/ca.pem \
   --ssl-cert=/tmp/newcerts/client-cert.pem \
   --ssl-key=/tmp/newcerts/client-key.pem \
   -h IP.IP.IP.IP -u USER -p \
   --ssl-verify-server-cert=true
  
  ERROR 2026 (HY000): SSL connection error: SSL certificate validation failure
  </code></pre>
  
  <p>In the case where I set <em>--ssl-verify-server-cert=false</em> mysql does not verify the self-signed certs and start the secure connexion.</p>
  
  <p>I've used the Mysql HowTo article to create my self-signed certificate : <a href="https://dev.mysql.com/doc/refman/5.6/en/creating-ssl-files-using-openssl.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.6/en/creating-ssl-files-using-openssl.html</a> and the openssl verify command is returning :</p>
  
  <pre><code>openssl verify -CAfile ca.pem server-cert.pem client-cert.pem
  
  server-cert.pem: OK
  client-cert.pem: OK
  </code></pre>
  
  <p>The ca.pem &amp; client-cert.pem &amp; server-cert.pem have been created with a different Common Name as Node1 for ca.pem, Node2 for client-cert.pem, Node3 for server-cert.pem</p>
  
  <p>Param loaded into Mysql during startup :</p>
  
  <pre><code>ssl-ca=/tmp/newcerts/ca.pem
  ssl-cert=/tmp/newcerts/server-cert.pem
  ssl-key=/tmp/newcerts/server-key.pem
  </code></pre>
  
  <p>Then I've added the ca.pem to the server by following those steps for RHEL6 :</p>
  
  <pre><code>update-ca-trust force-enable
  cp /tmp/newcerts/ca.pem /etc/pki/ca-trust/source/anchors/
  update-ca-trust extract
  </code></pre>
  
  <p>I'm guessing with a proper cert verified by a trusted third party I should not have this error but I need to verify that it work with a self-signed cert.</p>
  
  <p>I running out of idea to get this working. Does someone already faced a similar issue?</p>