How to Set Online SQL Server for Node.js ?

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:

  1. You can visit the link Install sql module. You can install this package by using this command.
    npm install sql
  2. After installing sql you can check your sql version in command prompt using the command.
    npm version sql
  3. 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
  4. 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:
    dashboard
  5. 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 myPhpAdminn portal. Now login with username and password and there you go, you can now create tables and do all SQL operations.
  6. Now to connect with this database, write down the following code in your index.js file.

Filename: index.js

filter_none

edit
close

play_arrow

link
brightness_4
code

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)
})

chevron_right


Steps to run the program:

  1. The project structure will look like this:
    project structure
  2. Make sure you need install sql by using following commands:
    npm install sql
  3. Run index.js file using below command:
    node index.js

    Output of above command

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

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.