MySQL 관련 주요 팁 (feat. Node.js)

MySQL의 기본 인코딩을 UTF-8로 지정하기

http://appletree.or.kr/blog/notes/mysql%EC%9D%98-%EA%B8%B0%EB%B3%B8-%EC%9D%B8%EC%BD%94%EB%94%A9default-encoding%EC%9D%84-utf8%EC%9C%BC%EB%A1%9C-%EC%84%A4%EC%A0%95%ED%95%98%EA%B8%B0/comment-page-1/

MySQL charset 설정 확인 방법

http://ffstory.tistory.com/entry/MYSQL%EC%97%90%EC%84%9C-charset-%EC%84%A4%EC%A0%95-%ED%99%95%EC%9D%B8-%EB%B0%A9%EB%B2%95

MySQL 페이징쿼리 구현하기

http://jsonobject.tistory.com/176

MySQL 테이블 생성시 DATETIME 타입에 DEFAULT로 현재 시간 입력하기

http://jsonobject.tistory.com/122

MySQL Insert시 중복 체크하기

http://do0park.blog.me/40134359319

Node.js+MySQL 연동시 타임 아웃 문제 처리 방법

http://ellehu.com/board_qfTg01/2624

http://berr.tistory.com/222

MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server

Execute the following query in MYSQL Workbench

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

Where root as your user localhost as your URL and password as your password

Then run this query to refresh privileges:

flush privileges;

Try connecting using node after you do so.

If that doesn't work, try it without @'localhost' part.