April 20, 2023

How To Connect MySql To Node.js Server


MySQL is a popular relational database management system that is widely used in web applications. In this tutorial, we will guide you through the process of connecting MySQL to a Node.js server on Ubuntu 20.04.

Step 1: Install MySQL Server

The first step is to install the MySQL server on your Ubuntu 20.04 machine. You can install MySQL server by running the following command in the terminal:

sudo apt-get install mysql-server

Step 2: Start the MySQL Service

After installing the MySQL server, start the service using the following command:

sudo systemctl start mysql

Step 3: Configure MySQL Server

Once the MySQL service is started, you need to configure it by running the following command:

sudo mysql_secure_installation

This command will prompt you to set a root password, remove anonymous users, disallow remote root login, and remove the test database. It is recommended that you follow these prompts to secure your MySQL server.

Step 4: Install the MySQL NPM Package

To connect your Node.js server to the MySQL database, you will need to install the MySQL NPM package. You can install this package by running the following command:

npm install mysql

Step 5: Create a Connection Object

After installing the MySQL NPM package, you need to create a connection object in your Node.js server. This can be done using the following code:

const mysql = require(‘mysql’);
const connection = mysql.createConnection({
host: ‘localhost’,
user: ‘root’,
password: ‘yourpassword’,
database: ‘yourdatabase’
Replace ‘yourpassword’ and ‘yourdatabase’ with your MySQL root password and the name of the database you want to connect to.

Step 6: Test the Connection

Finally, test the connection by running the following code:

connection.connect((err) => {
if (err) {
console.error(‘Error connecting to MySQL database: ‘ + err.stack);
console.log(‘Connected to MySQL database.’);

This code will log an error message if there is a problem connecting to the database or a success message if the connection is successful.


In this tutorial, we have learned how to connect MySQL to a Node.js server on Ubuntu 20.04. By following the steps outlined in this tutorial, you should now be able to connect your Node.js server to a MySQL database, allowing you to store and retrieve data from the database in your web application.

Buy USA Dedicated Server

Popular Blog Posts