Compose Database-as-a-Service Help and Documentation

Everything you need to know about Compose, Hosted or Enterprise, is here in our help system. Whether you run one database for your businesses' sole application or six different databases to support an entire corporation, we've got the information you need.

JavaScript, Node.js and Compose for MySQL

The leading driver for MySQL for Node.js is the node-mysql driver. We'll walk through setting up a simple Node.js/MySQL connection here. If you want to follow along, make sure that Node.js and npm are installed on your system.

After initializing a new project using npm init, install the driver package in the project’s folder:

npm install mysql --save

The driver and its dependencies are installed in the node_modules folder, and the driver will appear under dependencies in the package.json file.

You can use the following code to connect to MySQL.

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

const connection = mysql.createConnection(  
    {
        host: 'aws-us-east-1-portal.23.dblayer.com',
        port: 15942,
        user: 'admin',
        password: 'mypass',
        ssl: {
            ca: fs.readFileSync(__dirname + '/cert.crt')
        }
});

connection.query('SHOW DATABASES', (err, rows) => {  
    if (err) throw err;
    console.log('Connected!');
    for (let i = 0, len = rows.length; i < len; i++) {
        console.log(rows[i]['Database'])
    }
});

Notes

  • SHOW DATABASES is a MySQL command that lists the databases that a user has privileges for.
  • All the databases in the deployment are displayed because the script uses the admin user.
  • The results of the query are returned as an array of objects.

Still Need Help?

If this article didn't solve things, summon a human and get some help!

Updated about a year ago

JavaScript, Node.js and Compose for MySQL


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.