title: Connecting to MariaDB with nodejs over ssl with clear text password
body: <p>I am trying to connect to mariadb instance over ssl,</p>
  
  <pre><code>var mysql = require('mysql');
  var conn = mysql.createConnection({
      user: 'user',
      password: 'password',
      debug: true,
      port: '3306',
      host: "host",
      ssl: {
          "ca": ca
      }
  });
  
  conn.connect();
  </code></pre>
  
  <p>the ca is an array of cerificates. I am getting the following error.</p>
  
  <pre><code>Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MariaDB client
  </code></pre>
  
  <p>I am able to connect to the db using python with mysql.connector.</p>
  
  <p>After setting it on debug mode, I can see the client is trying to use mysql_native_password authentication. I need to use mysql_clear_password.</p>