*mysql설치
C:\ProgramData\MySQL\MySQL Server 5.7\my.ini - 관리자권한으로 메모장 열기
[client]
default-character-set=utf-8
# pipe=
# socket=MYSQL
port=3306
[mysql]
no-beep
default-character-set=utf-8
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
# server_type=3
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server=utf8
방화벽 설정
제어판 > 방화벽 >
3306 인바운드 열기
한글 설정 참고
https://blog.naver.com/codingspecialist/221329460456
'IT > Mysql' 카테고리의 다른 글
| sql 기본용어 정리 (0) | 2018.07.23 |
|---|---|
| Mysql - substr, in, left outer join, group by, FOREIGN KEY (0) | 2018.07.23 |
| Mysql - select, subquery, group by, having (0) | 2018.07.23 |
| Mysql - JOIN, OUTER JOIN (0) | 2018.07.23 |
| Mysql - AVG, COUNT, SUM, MIN, MAX, GROUP BY, HAVING, DATE_FORMAT (0) | 2018.07.23 |