mysql-node-express - GitLite

KO | EN

gitlite — search

#javascript #hacktoberfest #react #typescript #golang #go #machine-learning #deep-learning #linux #macos #java #cli #openai #open-source

mysql-node-express

(★ 99)

No description available.

파일 탐색기

최종 버전 다운로드 (.zip)

- - user.controller.js
- - create-user-db.sql
  - db-connection.js
- - auth.middleware.js
  - awaitHandlerFactory.middleware.js
  - error.middleware.js
- - user.model.js
- - user.route.js
- - common.utils.js
  - HttpException.utils.js
  - userRoles.utils.js
- server.js
.env-example
.gitignore
nodemon.json
package-lock.json
package.json
README.md

# 설치 가이드

1. 코드 내려받기

git clone https://github.com/Juliest88/mysql-node-express

깃허브에서 프로젝트 코드 전체를 내 컴퓨터로 내려받습니다.

cd mysql-node-express

방금 내려받은 프로젝트 폴더 안으로 이동합니다.

2. Node.js

쉬움 추천

사전 준비물

Git GitHub에서 프로젝트 코드를 내려받으려면 필요합니다.
Node.js npm 명령어를 쓰려면 Node.js가 설치되어 있어야 합니다. LTS(장기지원) 버전을 추천합니다.

npm install

package.json에 명시된 라이브러리들을 내려받아 설치합니다.

npm start

개발/실행 서버를 켭니다.

✅ 명령어 실행 후 터미널에 나타나는 주소(보통 http://localhost:3000 형태)를 브라우저에서 열어보세요.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# How to Build Rest API with NodeJs, Express and Mysql

### Tech

This example uses a number of open source projects to work properly:

* [node.js]
* [Express]
* [mysql2]
* [bcryptjs]
* [jsonwebtoken]
* [express-validator]
* [dotenv]
* [cors]

### Getting Started

``` sh
# Clone this repo to your local machine using
git clone git@github.com:Juliest88/mysql-node-express.git

# Get into the directory
cd mysql-node-express

# Make it your own
rm -rf .git && git init

# Coppy .env-example and create your own .env file
cp .env-example .env

# Edit .env file and add your mysql username, mysql password and db name
vi .env
# you can edit the file also via text editor

# Get into the db directory
cd src/db

# Import mysql database using Command line
mysql -u [db_username] -p[db_password] < create-user-db.sql
# you can edit the file if you want to change the db_name
# if you are using a different db_name and it elready exists,
# you can comment the first two lines, remain the line => USE test_db;
# and just change the db_name

# Install dependencies
npm install

# Run the server locally
npm start

# Run the server locally in dev mode
npm run dev
```

**Enjoy :)**

[//]: # (These are reference links used in the body of this note and get stripped out when the markdown processor does its job. There is no need to format nicely because it shouldn't be seen. Thanks SO - http://stackoverflow.com/questions/4823468/store-comments-in-markdown-syntax)

[git-repo-url]: <https://github.com/Juliest88/mysql-node-express.git>
   [node.js]: <http://nodejs.org>
   [express]: <http://expressjs.com>
   [mysql2]: <https://github.com/sidorares/node-mysql2#readme>
   [bcryptjs]: <https://github.com/dcodeIO/bcrypt.js#readme>
   [jsonwebtoken]: <https://github.com/auth0/node-jsonwebtoken#readme>
   [express-validator]: <https://express-validator.github.io/docs/>
   [dotenv]: <https://github.com/motdotla/dotenv#readme>
   [cors]: <https://github.com/expressjs/cors#readme>