
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.

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
How to use the endsWith method in JavaScript
In this short tutorial, we are going to see what the endsWith method, introduced in JavaScript ES6, is and how it is used with strings in JavaScript. The endsWith method is…
What are javascript symbols and how can they help you?
Symbols are a new primitive value introduced by ES6. Their purpose is to provide us unique identifiers. In this article, we tell you how they work, in which way they…
Callbacks in JavaScript
Callback functions are the same old JavaScript functions. They have no special syntax, as they are simply functions that are passed as an argument to another function. The function that receives…
How to create PDF with JavaScript and jsPDF
Creating dynamic PDF files directly in the browser is possible thanks to the jsPDF JavaScript library. In the last part of this article we have prepared a practical tutorial where I…
How to make your own custom cursor for your website
When I started browsing different and original websites to learn from them, one of the first things that caught my attention was that some of them had their own cursors,…
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…