Azure MySQL modules for JavaScript

The recommended client library for accessing Azure Database for MySQL is the open-source JavaScript connection library for Azure Database for MySQL.

Learn more about Azure Database for MySQL

Client Package

Install the npm module

Use npm to install the MySQL client module.

npm install mysql2

Example

This example connects to a MySQL database and performs a simple query to retrieve all customers.

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

const connection = mysql.createConnection({
  host: 'mysqldemo.mysql.database.azure.com',
  user: 'myadmin@mysqldemo',
  password: 'your_password',
  database: 'my_db',
  port: 3306,
  ssl: {ca: fs.readFileSync("your_path_to_ca_cert_file_BaltimoreCyberTrustRoot.crt.pem")}
});

connection.connect();
const query = 'SELECT * FROM customers';
connection.query(query, (err, res) =>
  console.log(`We have ${res.length} customers`)
);

connection.end();

Samples

• Create a connection to MySQL using JavaScript
• Perform queries using JavaScript and MySQL
• MySQL transactions in JavaScript

For more code samples that use various Azure packages, explore the JavaScript samples.

Management SDK

Create, update, or delete MySQL instances using Management SDK

Installation

npm install @azure/arm-mysql

Example code

Examples for using this module in Node.js as well as browser applications can be found in the README for the module