Connecting to MariaDB with nodejs over ssl with clear text password

I am trying to connect to mariadb instance over ssl,

        var mysql = require('mysql');
        var conn = mysql.createConnection({
        user: 'user',
        password: 'password',
        debug: true,
        port:'3306',
        host:"host",
        ssl:{
            "ca":ca
        }
        });

        conn.connect();

the ca is an array of cerificates. I am getting the following error.

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MariaDB client

I am able to connect to the db using python with mysql.connector.

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.

via Shashi Mishra