azure-arm-mysql

Microsoft Azure SDK for Node.js - MySQL Management

This project provides a Node.js package that makes it easy to manage Microsoft Azure MySQL Resources. Right now it supports:

• Node.js version: 6.x.x or higher

How to Install

npm install azure-arm-mysql

How to Use

Listing servers

const msRestAzure = require('ms-rest-azure');
const MySQLManagementClient = require('azure-arm-mysql');

const subscriptionID = '<subscription id>';
const resourceGroup = '<resource group name>';

msRestAzure.interactiveLogin().then((credentials) => {
  let client = new MySQLManagementClient(credentials, subscriptionID);
  return client.servers.listByResourceGroup(resourceGroup);
}).then((servers) => {
  console.log('List of servers:');
  console.dir(servers, {depth: null, colors: true});
}).catch((err) => {
  console.log('An error ocurred');
  console.dir(err, {depth: null, colors: true});
});

Creating a server

const msRestAzure = require('ms-rest-azure');
const MySQLManagementClient = require('azure-arm-mysql');

const subscriptionID = '<subscription id>';
const resourceGroup = '<resource group name>';
const serverName = '<server name>'; // must be globally unique

msRestAzure.interactiveLogin().then((credentials) => {
  let client = new MySQLManagementClient(credentials, subscriptionID);
  return client.servers.createOrUpdate(resourceGroup, serverName, {
    location: 'eastus',
    properties: {
      createMode: 'Default',
      administratorLogin: 'mysql',
      administratorLoginPassword: 'F00Bar!!'
    }
  });
}).then((server) => {
  console.log('Server:');
  console.dir(server, {depth: null, colors: true});
}).catch((err) => {
  console.log('An error ocurred');
  console.dir(err, {depth: null, colors: true});
});

Listing databases

const msRestAzure = require('ms-rest-azure');
const MySQLManagementClient = require('azure-arm-mysql');

const subscriptionID = '<subscription id>';
const resourceGroup = '<resource group name>';
const serverName = '<server name>';

msRestAzure.interactiveLogin().then((credentials) => {
  let client = new MySQLManagementClient(credentials, subscriptionID);
  return client.databases.listByServer(resourceGroup, serverName);
}).then((databases) => {
  console.log('List of databases:');
  console.dir(databases, {depth: null, colors: true});
}).catch((err) => {
  console.log('An error ocurred');
  console.dir(err, {depth: null, colors: true});
});

Creating a database

const msRestAzure = require('ms-rest-azure');
const MySQLManagementClient = require('azure-arm-mysql');

const subscriptionID = '<subscription id>';
const resourceGroup = '<resource group name>';
const serverName = '<server name>';
const databaseName = '<database name>';

msRestAzure.interactiveLogin().then((credentials) => {
  let client = new MySQLManagementClient(credentials, subscriptionID);
  return client.databases.createOrUpdate(resourceGroup, serverName, databaseName, {});
}).then((database) => {
  console.log('Database:');
  console.dir(database, {depth: null, colors: true});
}).catch((err) => {
  console.log('An error ocurred');
  console.dir(err, {depth: null, colors: true});
});

Deleting a database

const msRestAzure = require('ms-rest-azure');
const MySQLManagementClient = require('azure-arm-mysql');

const subscriptionID = '<subscription id>';
const resourceGroup = '<resource group name>';
const serverName = '<server name>';
const databaseName = '<database name>';

msRestAzure.interactiveLogin().then((credentials) => {
  let client = new MySQLManagementClient(credentials, subscriptionID);
  return client.databases.deleteMethod(resourceGroup, serverName, databaseName);
}).then(() => {
  console.log('Database deleted');
}).catch((err) => {
  console.log('An error ocurred');
  console.dir(err, {depth: null, colors: true});
});

Deleting a server

const msRestAzure = require('ms-rest-azure');
const MySQLManagementClient = require('azure-arm-mysql');

const subscriptionID = '<subscription id>';
const resourceGroup = '<resource group name>';
const serverName = '<server name>';

msRestAzure.interactiveLogin().then((credentials) => {
  let client = new MySQLManagementClient(credentials, subscriptionID);
  return client.servers.createOrUpdate(resourceGroup, serverName, {
    location: 'eastus',
    properties: {
      createMode: 'Default',
      administratorLogin: 'mysql',
      administratorLoginPassword: 'F00Bar!!'
    }
  });
}).then((server) => {
  console.log('Server:');
  console.dir(server, {depth: null, colors: true});
}).catch((err) => {
  console.log('An error ocurred');
  console.dir(err, {depth: null, colors: true});
});

Related projects

• Microsoft Azure SDK for Node.js