title: MySQL - SSL is required but the server doesn't support it
body: <p>I'm trying to enable SSL in MySQL. I ran the SSL Wizard on MySQL Workbench which generated these files:</p>
  
  <ul>
  <li><code>ca-cert.pem</code></li>
  <li><code>ca-key.pem</code></li>
  <li><code>client-cert.pem</code></li>
  <li><code>client-key.pem</code></li>
  <li><code>server-cert.pem</code></li>
  <li><code>server-key.pem</code></li>
  </ul>
  
  <p>Then I changed <code>my.cnf</code> file like this:</p>
  
  <pre><code>[client]
  ssl-ca=&lt;directory&gt;/ca-cert.pem
  ssl-cert=&lt;directory&gt;/client-cert.pem
  ssl-key=&lt;directory&gt;/client-key.pem
  
  [mysqld]
  ssl-ca=&lt;directory&gt;/ca-cert.pem
  ssl-cert=&lt;directory&gt;/server-cert.pem
  ssl-key=&lt;directory&gt;/server-key.pem
  </code></pre>
  
  <p>where <code>&lt;directory&gt;</code> is the directory where these files are located.</p>
  
  <p>Then I set the configuration file path in MySQL Workbench and restarted mysql service but when I test the connection it gives me this error: </p>
  
  <blockquote>
    <p>ERROR 2026 (HY000): SSL connection error: SSL is required but the
    server doesn't support it</p>
  </blockquote>
  
  <p>How can I solve this?</p>