バインドExpress(Node.js)+Mysql(1)

Express(Node.js)でMysql DBをバインドする

// mysql
npm i mysql
// env
npm i donenv

環境変数.envファイルの追加

.env
DB_HOST = localhost
DB_USER = root
DB_PASSWORD = user_password
DB = Your_Database_Name

├── Express
│ ├── node_modules
│ └─── package.json
│ └─── .env
│ └─── server.js

server.js
const express = require("express");
const app = express();
const port = process.env.PORT || 3000;
const mysql = require("mysql");

require("dotenv").config();

app.use(express.json());
app.use(express.urlencoded({ extended: true }));
app.use(cors());


// mysql 연동
const connection = mysql.createConnection({
   host: process.env.DB_HOST,
   user: process.env.DB_USER,
   password: process.env.DB_PASSWORD,
   database: process.env.DB,
});

connection.connect();

app.listen(port, () => {
  console.log(`server is listening at localhost:` + port);
});