MySQL

MySQL 데이터베이스 개발 환경 구축 오류 해결

MySQL Community Installer 페이지 services.msc에서 MySQL 80 시작

Default Schema 설정

root에서 sql로 user와 database를 설정해줬다면
default schema에는 설정한 database의 이름이
user에는 설정한 user Name을 넣어줘야 한다.

Name		Name	Last commit message	Last commit date
10-1_select.txt		10-1_select.txt
10-2_select.txt		10-2_select.txt
10-3_select.txt		10-3_select.txt
10-4_select.txt		10-4_select.txt
10-5_select.txt		10-5_select.txt
10-6_select.txt		10-6_select.txt
10-7_select.txt		10-7_select.txt
11-1_update.txt		11-1_update.txt
11-2_update.txt		11-2_update.txt
11-3_update.txt		11-3_update.txt
11-4_update.txt		11-4_update.txt
11-5_update.txt		11-5_update.txt
11-6_delete.txt		11-6_delete.txt
11-7_deleteIN.txt		11-7_deleteIN.txt
12-1_truncate		12-1_truncate
12-2_insert		12-2_insert
13-1_createTable		13-1_createTable
13-2_insert.txt		13-2_insert.txt
13-3_join.txt		13-3_join.txt
13-4_fieldAs.txt		13-4_fieldAs.txt
13-5_leftJoin.txt		13-5_leftJoin.txt
14-1_createTable.txt		14-1_createTable.txt
14-2_insert		14-2_insert
14-3_count.txt		14-3_count.txt
14-4_count.txt		14-4_count.txt
14-5_sum.txt		14-5_sum.txt
14-6_avg.txt		14-6_avg.txt
14-7_max.txt		14-7_max.txt
14-7_min.txt		14-7_min.txt
15-1_groupBy.txt		15-1_groupBy.txt
15-2_groupBy.txt		15-2_groupBy.txt
15-3_having.txt		15-3_having.txt
16-1_orderBy.txt		16-1_orderBy.txt
16-2_orderBy.txt		16-2_orderBy.txt
16-3_orderBy.txt		16-3_orderBy.txt
17-1_limit.txt		17-1_limit.txt
17-2_limit.txt		17-2_limit.txt
17-3_limit.txt		17-3_limit.txt
18-1_createTable.txt		18-1_createTable.txt
18-2_insert.txt		18-2_insert.txt
18-3_union.txt		18-3_union.txt
18-4_union.txt		18-4_union.txt
19-1_subQuery.txt		19-1_subQuery.txt
19-2_subQuery.txt		19-2_subQuery.txt
19-3_subQuery.txt		19-3_subQuery.txt
20-1_unique.txt		20-1_unique.txt
20-2_insert.txt		20-2_insert.txt
21-1_concat.txt		21-1_concat.txt
21-2_concat.txt		21-2_concat.txt
22-1_index.txt		22-1_index.txt
22-2_indexUnique.txt		22-2_indexUnique.txt
3-1_createDatabase.txt		3-1_createDatabase.txt
3-2_showDatabases.txt		3-2_showDatabases.txt
3-3_useDatabase.txt		3-3_useDatabase.txt
6-1_createTable.txt		6-1_createTable.txt
6-2_desc.txt		6-2_desc.txt
7-1_alterADD.txt		7-1_alterADD.txt
7-2_alterMODIFY.txt		7-2_alterMODIFY.txt
7-3_alterDROP.txt		7-3_alterDROP.txt
7_testTable.txt		7_testTable.txt
8_dropTable.txt		8_dropTable.txt
9-1_insert.txt		9-1_insert.txt
9-2_insert.txt		9-2_insert.txt
9-3_insert.txt		9-3_insert.txt
README.md		README.md
부록_실습 소프트웨어 설치.pdf		부록_실습 소프트웨어 설치.pdf

Navigation Menu

Repository files navigation

MySQL

MySQL 데이터베이스 개발 환경 구축 오류 해결

Default Schema 설정

About

Releases

Packages

Contributors

Latest commit

History

Folders and files

Repository files navigation

MySQL

MySQL 데이터베이스 개발 환경 구축 오류 해결

Default Schema 설정

About

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors