How to connect azure mysql server with node.js?

@herminia_bruen 

To connect an Azure MySQL server with Node.js, you can follow these steps:

Step 1: Install the required packages Ensure that you have Node.js and npm (Node Package Manager) installed on your machine. Then, in your project directory, open the command prompt and run the following command to install the required packages:

1

npm install mysql

Additionally, you can install the dotenv package to securely store your database credentials in a .env file:

1

npm install dotenv

Step 2: Obtain Azure MySQL server connection details To connect to your Azure MySQL server, you need to gather the following information:

• Hostname: the server's address.
• Username: the username for accessing the database.
• Password: the password for the specified user.
• Database name: the name of the database you want to connect to.

Step 3: Configure your Node.js application Create a new JavaScript file, e.g., app.js, and open it in your text editor. Import the required modules and configure the database connection as follows:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

require('dotenv').config(); // Load environment variables from .env file
const mysql = require('mysql');

const connection = mysql.createConnection({
  host: process.env.HOSTNAME,     // Replace with your hostname
  user: process.env.USERNAME,     // Replace with your username
  password: process.env.PASSWORD, // Replace with your password
  database: process.env.DATABASE  // Replace with your database name
});

connection.connect((error) => {
  if (error) throw error;
  console.log('Connected to the Azure MySQL server');
});

Step 4: Create a .env file In your project directory, create a new file named .env and add your Azure MySQL server connection details. For example:

1
2
3
4

HOSTNAME=your_hostname
USERNAME=your_username
PASSWORD=your_password
DATABASE=your_database

Be sure not to include this file in your version control system (e.g., Git) to avoid exposing sensitive information.

Step 5: Test the connection To ensure that the connection is working correctly, run the Node.js application:

1

node app.js

If the connection is successful, you will see the message "Connected to the Azure MySQL server" in the console.

That's it! You have successfully connected Azure MySQL server with your Node.js application. Now, you can use the mysql object (connection) to perform various database operations like executing queries, fetching data, etc.