What's the best Node.js mysql module for connecting to mysql over ssl?

Question

I've built my app so far using node-mysql. I just set up a securely accessible mysql database using AWS RDS service and have tested an SSL connection successfully with the mysql command line client. I have Amazon's public key .pem file. node-mysql doesn't seem to have an api for the SSL connect option.

The only one I've found so far is Node-mysql-libmysqlclient but I got errors trying to connect with it, something about a bindings dependency being null so I'm not sure if I should trust it. Suggestions of which module/api to use? Alternatively, if you know what I need to modify in node-mysql I'd be willing to tinker a bit but it looks like it's using lower level Sockets to connect to MySQL so I'm not sure how hard it would be to get the SSL part added on.

FYI to connect with the command line mysql client all that's needed is, "mysql -h host -u username -ssl_ca=mysql-ssl-ca-cert.pem -p" where mysql-ssl-ca-cert.pem is a public key file provided by Amazon. I didn't need to generate any other keys or certificates. — ABCD.ca, Oct 08 '12 at 22:16

score 10 · Answer 1 · answered Aug 06 '16 at 21:18

var mysql  = require('mysql');
var fs     = require('fs');

var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'me',
  password : 'secret',
  database : 'my_db',
  ssl      : {
        ca   : fs.readFileSync('./ssl/server-ca.pem'), // should be enough for AWS
        key  : fs.readFileSync('./ssl/client-key.pem'), // required for google mysql cloud db
        cert : fs.readFileSync('./ssl/client-cert.pem'), // required for google mysql cloud db
  }
});

that should do the trick.

score 0 · Answer 2 · answered Oct 28 '14 at 09:41

0

The node-mysql module supports ssl connections as showed here: https://github.com/felixge/node-mysql#ssl-options.

answered Oct 28 '14 at 09:41

matteo

1,635
1
15
26

buycanna.io · Accepted Answer · 2020-04-23T02:14:33.270

-4

Use Sequelize! Hands down best ORM around for MariaDB/MySQL. https://github.com/sequelize/sequelize

npm install sequelize
--- then ---
npm install mariadb
--- or ---
npm install mysql

edited Apr 23 '20 at 02:14

answered Apr 08 '18 at 08:51

buycanna.io

1,166
16
18

2

why all the downvotes without any comment as to why? – linkD Apr 21 '20 at 15:37

What's the best Node.js mysql module for connecting to mysql over ssl?

3 Answers3