MySQL with Node.js

main.js

const mysql = require('mysql');
const express = require('express');
var app = express();
const bodyparser = require('body-parser');

app.use(bodyparser.json());

var mysqlConnection = mysql.createConnection({
	host : '13.124.119.246',
	user : 'root',
	password : 'root',
	database : 'USER',
	port : '56891'
});

mysqlConnection.connect((err)=>{
	if (!err) {
		console.log("연결됨");
	}else{
		console.log("연결 실패");
	}
});

app.listen(3000, ()=>console.log('express서버가 3000번 포트로 열렸어요!'));
app.get('/user', (res, req)=> {
	mysqlConnection.query('SELECT * FROM USER', (err, rows, fields)=>{
		if(!err){
			console.log(rows);
		}else{
			console.log(err);
		}
	});
});