How to connect to MySQL with Node.js

by Silvia Mazzetta Date: 04-11-2021 javascript nodejs mysql


Let's see how you can connect to a MySQL database using Node.js, the popular JavaScript runtime environment.

Before we start, it is important to note that you must have Node.js installed on your system. Likewise, you must create a MySQL database.

 

Create a MySQL database

 

If you haven't already done so, you can create the database in any way you like. You can create it using applications such as phpMyAdmin or manually using the MySQL command line. To create it via the command line, follow these steps:

Connect to MySQL from the command line and enter the password when prompted:

 
mysql -u USER -p
 

Create a sample table, which in this case we will call employees:

 
CREATE DATABASE employees;
 

Select the database you have just created:

USE employees;

Create a table in the database:

 
CREATE TABLE IF NOT EXISTS employees (    
id int(11) NOT NULL AUTO_INCREMENT,    
name varchar(50),    
PRIMARY KEY (id)  
);
 

Insert some example data in the table:

 
INSERT INTO employees (nombre) VALUES ("Silvia");  
INSERT INTO employees (nombre) VALUES ("Luigi");  
INSERT INTO employees (nombre) VALUES ("Alejandro");
 

You can now run queries on the table.

Install node-mysql

You will need to have the node-mysql package installed, so if you don't have it installed, you will need to install it. To do this you must use the npm package manager:

 
npm install mysql
 

After installing node-mysql you will be able to connect to the database via Node.js.

 

Establish the MySQL connection

 

Create a Node.js script.

The first thing we do in this example is create a connection object to the MySQL database.

We use the table employees as an example, but replace it with the name of the database you want to use. Similarly, replace USER and PASS with the MySQL user data.

 
var mysql = require('mysql');  
var conexion= mysql.createConnection({      
   host : 'localhost',      
   database : 'employees',      
   user : 'USER',      
   password : 'PASS',  
});    
conexion.connect(function(err) {     
   if (err) {          
       console.error('Error de conexion: ' + err.stack);          
       return;      
   }      
   console.log('Connected to the identifier ' + conexion.threadId); 
});
 

Once the connection is established, you will be able to execute queries using the query method:

 
conexion.query('SELECT * FROM empleados', function (error, results, fields) {
      if (error)          
          throw error;        
      results.forEach(result => {          
      console.log(result);      
      });  
});
 

Finally, terminate the connection:

 
connection.end();

And that's it. If you want more information about node-mysql, we recommend you to consult this guide.

 
by Silvia Mazzetta Date: 04-11-2021 javascript nodejs mysql hits : 5073  
 
Silvia Mazzetta

Silvia Mazzetta

Web Developer, Blogger, Creative Thinker, Social media enthusiast, Italian expat in Spain, mom of little 7 years old geek, founder of  @manoweb. A strong conceptual and creative thinker who has a keen interest in all things relate to the Internet. A technically savvy web developer, who has multiple  years of website design expertise behind her.  She turns conceptual ideas into highly creative visual digital products. 

 
 
 

Related Posts

Node.js and npm: introductory tutorial

In this tutorial we will see how to install and use both Node.js and the npm package manager. In addition, we will also create a small sample application. If you…

JavaScript Programming Styles: Best Practices

When programming with JavaScript there are certain conventions that you should apply, especially when working in a team environment. In fact, it is common to have meetings to discuss standards…

Difference between arrow and normal functions in JavaScript

In this tutorial we are going to see how arrow functions differ from normal JavaScript functions. We will also see when you should use one and when you should use…

JavaScript Arrow functions: What they are and how to use them

In this article we are going to see what they are and how to use JavaScript Arrow Functions, a new feature introduced with the ES6 standard (ECMAScript 6). What are Arrow…

How to insert an element into an array with JavaScript

In this brief tutorial you will learn how to insert one or more elements into an array with JavaScript. For this we will use the splice function. The splice function will not…

What is the difference between primitives types and objects in JavaScript?

In this short tutorial we are going to look at the differences between primitive types and objects in JavaScript. To start with, we're going to look at what primitive types…

How to get DOM elements with JavaScript

When you access any element of the DOM, it is usual to save it in a variable. This is something that at first might seem very simple, but if you…

How to reverse an array in JavaScript

In this tutorial we are going to see how you can change the order of the elements of an array so that they are inverted. You could use a loop…

How synchronize the scroll of two divs with JavaScript

In case you have two divs of different sizes you may sometimes want to scroll both at the same time but at different speeds depending on their size. For example,…

How to use the codePointAt method in JavaScript

The JavaScript codePointAt method has more or less the same function as the charCodeAt method, used to get the 16-bit Unicode representation of the character at a certain position in…

How to check if a value is a number in JavaScript

In this short tutorial we are going to look at the various methods that exist to find out if a value is a number in JavaScript.   1. Using the isNaN() function   One…

How to use the charCodeAt method in JavaScript

The charCodeAt method is accepted by strings in JavaScript, returning the 16-bit Unicode code of the character at the position we pass as a parameter to the method. The charCodeAt method…

We use our own and third-party cookies to improve our services, compile statistical information and analyze your browsing habits. This allows us to personalize the content we offer and to show you advertisements related to your preferences. By clicking "Accept all" you agree to the storage of cookies on your device to improve website navigation, analyse traffic and assist our marketing activities. You can also select "System Cookies Only" to accept only the cookies required for the website to function, or you can select the cookies you wish to activate by clicking on "settings".

Accept All Only sistem cookies Configuration