How to Set Online SQL Server for Node.js ?

An Online SQL server helps to connect your project with an online server instead of localhost database setup. To achieve this, the remotemysql site is popular for providing an online database to store our data in a secure way. 

Installation of sql module:

• You can visit the link Install sql module. You can install this package by using this command.

npm install sql

• After installing sql you can check your sql version in command prompt using the command.

npm version sql

• After that, you can just create a folder and add a file for example index.js, To run this file you need to run the following command.

node index.js

• Now go to remotemysql official website and create an account and login, then go to your ‘DATABASES’ section and simply click on ‘CREATE NEW DATABASE’ button. After that you will see the details of your database as shown below:
• Now save these details as this will be required in connection code. Now click on ‘ACTION’ button which is just next to your recently created database and select ‘phpMyAdmin’. Now you will be redirected to your myPhpAdmin portal. Now login with username and password and there you go, you can now create tables and do all SQL operations.
• Now to connect with this database, write down the following code in your index.js file.

Filename: index.js

javascript

const mysql = require('mysql')

const connection = mysql.createConnection({
    host:'remotemysql.com',
    user:'Your_Username',
    password:'Your_Password',
    database:'Your_Database'
})

connection.query('SELECT NOW()', function(error, result){
    if(error) throw error
    console.log(result)
})

Steps to run the program:

• The project structure will look like this:
• Make sure you need install sql by using following commands:

npm install sql

• Run index.js file using below command:

node index.js

So this is how you can set up an online SQL server setup using remotemysql website.