MySQL Conecctionn ExpressJS

Connecting ExpressJS to MySQL and creating an API Endpoint.

V1.0.6

[ADD] Role Statement

V1.0.5

[ADD] Set request CORS in .env

V1.0.3

[ADD] Method Operation Created, Read, Update, & Delete

V1.0.2

[FIX] Cors Request

NPM Installation

npm i mysql-endpoint-express

Create & Configuration .env

DB_HOST=localhost
DB_PORT=5000
DB_USER=username
DB_PASSWORD=password
DB_DATABASE=database

PREFIX_ROLE='admin'
ALLOWED_ORIGIN='*'
ALLOWED_METHODS='GET, POST, PUT, DELETE'
ALLOWED_HEADERS='Content-Type, Authorization'

Implementation index.js

require('mysql-endpoint-express');

Run

node index.js`

Testing Endpoint

• Open in browser: http://localhost:3000/api
• go to our github repository to see the demo application