[New post] ER_CANNOT_RETRIEVE_RSA_KEY – error when connecting to MySQL with MariaDB npm package. How to fix?

Gayathri Kumaran posted: " When you connect to a MySQL Database with MariaDB npm package you might face this error. SqlError: (conn=37044, no: 45044, SQLState: 08S01) RSA public key is not available client side. Either set option `cachingRsaPublicKey` to indicate public key pat" New post on Poopcode ER_CANNOT_RETRIEVE_RSA_KEY – error when connecting to MySQL with MariaDB npm package. How to fix? by Gayathri Kumaran When you connect to a MySQL Database with MariaDB npm package you might face this error. To fix this just add "allowPublicKeyRetrieval": true to your connection properties. In my case I added this property to my connection pool config. Read more of this post Gayathri Kumaran | September 29, 2021 at 3:59 pm | Tags: allowPublicKeyRetrieval mysql, ER_CANNOT_RETRIEVE_RSA_KEY mariadb, ER_CANNOT_RETRIEVE_RSA_KEY mysql | Categories: SQL | URL: https://wp.me/pb9kQA-3wZ Comment    See all comments Unsubscribe to no longer receive posts from Poopcode. Change your email settings at Manage Subscriptions. Trouble clicking? Copy and paste this URL into your browser: https://poopcode.com/er_cannot_retrieve_rsa_key-error-when-connecting-to-mysql-with-mariadb-npm-package-how-to-fix/