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>';
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