![](https://upload.wikimedia.org/wikipedia/commons/thumb/d/d9/Node.js_logo.svg/1200px-Node.js_logo.svg.png)

#### What Will I Learn?

- Download XAMPP for apache & MySQL server with PHPMyAdmin
- installing MySQL package on nodejs
- setup MySQL server on nodejs server

#### Requirements

- NodeJS [Download](https://nodejs.org/en/)
- XAMPP [Download](https://www.apachefriends.org/download.html)

#### Difficulty

- Intermediate

#### Tutorial Contents
In this tutorial, you will learn how to install XAMPP, Install MySQL package and setup MySQL in NodeJS.

#### Curriculum

- [NodeJS Tutorials #1](https://utopian.io/utopian-io/@lonelywolf/nodejs-tutorials-1-creating-a-static-site-node-js)


#### Setup MySQL

### Step 1 - Setup Your NodeJS server

```
var app = require('http').createServer(handler);
var fs = require('fs');
app.listen(80);
```

`app` - creating the server.

`fs` - import file system package

`app.listen` - listening to the server.

```
function handler (req, res) {
  fs.readFile(__dirname + '/index.html',
  function (err, data) {
  if (err) {
  res.writeHead(500);
  return res.end('Error loading index.html');
  }

  res.writeHead(200);
  res.end(data);
  });
}
```

this function will open the server and read the `index.html` file if you have one.

if you want better explanation go to [here](https://utopian.io/utopian-io/@lonelywolf/nodejs-tutorials-1-creating-a-static-site-node-js)
### Step 2 - Install XAMPP
we need XAMPP to use MySQL server and we need apache to run phpmyadmin for easy usage with MySQL.

download the installer [here](https://www.apachefriends.org/download.html)

![image.png](https://cdn.utopian.io/posts/95ce86a1d879401e6829f091963fc210d3f2image.png)

![image.png](https://cdn.utopian.io/posts/0cd10b4e0960a26417261c734459534ad0a9image.png)

![image.png](https://cdn.utopian.io/posts/0d36cef666bd6375dac0845bf9f43f1b75c3image.png)

![image.png](https://cdn.utopian.io/posts/0ab1882916005889d39945a1b24b26abca3eimage.png)

After all of these steps, press `Next` and start the installation process.

when you have done you ready to run MySQL & Apache, we need apache to use phpmyadmin.

Go to your xampp directory and open `apache_start` and `mysql_start`

![image.png](https://cdn.utopian.io/posts/04f72b3950ea71aae2706fc297f95fd4dbdcimage.png)

![image.png](https://cdn.utopian.io/posts/78d48264cbb246b5aa771f3fd7d2060fedbfimage.png)


if all done correctly go to `http://localhost/phpmyadmin`

![image.png](https://cdn.utopian.io/posts/fdbe8c725fc8dd480a3da765757e25dd11a1image.png)

### Step 3 - Install MySQL package

use the command

```
npm install mysql --save
```

this command installs the MySQL package to NodeJS so you can use it on your server and in your script.

![image.png](https://cdn.utopian.io/posts/add4c7f85cf9f74e2162c3cc27c05dabf969image.png)

![image.png](https://cdn.utopian.io/posts/a82cd9e56e7c38845aa7f27496b018e53b05image.png)

import MySQL package to your server,

```
const mysql = require('mysql');
```

### Step 4 - Setup MySQL on NodeJS

setup config json variable with `hostname`, `user`, `password`, `database`

`hostname` - the hostname of the mysql server, for example, `127.0.0.1`.

`user` - the username of the mysql server.

`password` - the password of the mysql server.

`database` - the database name.

xampp defaults: `hostname: localhost`, `user: root`, `password: no password`.

create a database with phpmyadmin, for example `mysql_example`

```
const config = {
  "host": "localhost",
  "user": "root",
  "password": "",
  "base": "mysql_example"
};
```

now we need to create the connection

```
var db = mysql.createConnection({
  host: config.host,
  user: config.user,
  password: config.password,
  database: config.base
});
```

connection made with `hostname`, `user`, `password`, `database`.

`mysql.createConnection` - this function creates the connection and put it to the `db` variable.

now connect to the database

```
db.connect(function (error) {
  if (!!error)
  throw error;

  console.log('mysql connected to ' + config.host + ", user " + config.user + ", database " + config.base);
});
```

`db.connect` - connect to the database after you made the connection.

if all done correctly you will see this reult

![image.png](https://cdn.utopian.io/posts/01a317e3fbc91272bf05c27a9c4f4985598cimage.png)

##### part 2 - use MySQL to insert, import, update and delete data from the database

Part 2 "What will I learn?"

- Insert data into the database
- Extract data from the database
- Update data in the database
- Delete data from the database

<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@lonelywolf/nodejs-tutorials-3-mysql-part-1">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>