Nodejs and MySQL config

// MySQL and Nodejs config
const db = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : '',
  database : 'nodejs'
});

Install MySQL

first install mysql

npm install mysql

or

npm install mysqljs/mysql

install ExpressJs

npm install express

or

npm install --save express

or

npm i express

How to Setup this project

• step 1: git clone this project.

git clone https://github.com/CodeWithSushil/CRUD-app-in-Nodejs-and-MySQL.git

• step 2: go to project.

cd CRUD-app-in-Nodejs-and-MySQL

• step 3: install package or update package

npm install

or

npm update

• step 4: start your MySQL Server

mysqld_safe

• step 5: install nodemon

npm install --save nodemon

or if you want nodemon install globally

npm -g install nodemon

• step 6: how to run this app

nodemon start

• step 7: Open App URL

http://localhost:3000