DataBase/MySQL

[MySQL] ์„ค์น˜ ๋ฐ ๊ฐœ์š” (Windows 10)

728x90

 

1. MySQL์ด๋ž€ ?

๐Ÿ‘ฉ‍๐Ÿ’ป ์„ธ๊ณ„์—์„œ ๊ฐ€์žฅ ๋งŽ์ด ์“ฐ์ด๋Š” ์˜คํ”ˆ ์†Œ์Šค ๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ด€๋ฆฌ ์‹œ์Šคํ…œ(RDBMS)์œผ๋กœ
1994๋…„ ์Šค์›จ๋ด์—์„œ ๊ฐœ๋ฐœ๋˜๊ธฐ ์‹œ์ž‘ํ•œ ๋ฌด๋ฃŒ, ์˜คํ”ˆ์†Œ์Šค, RDBMS ์ด๋‹ค.

 

๐Ÿ” RDBMS๊ฐ€ ๋ญ”๋ฐ?

 

2. MySQL ์„ค์น˜

MySQL ๋‹ค์šด๋กœ๋“œ ์‚ฌ์ดํŠธ :  dev.mysql.com/downloads/mysql/

 

MySQL :: Download MySQL Community Server

Select Operating System: Select Operating System… Microsoft Windows Ubuntu Linux Debian Linux SUSE Linux Enterprise Server Red Hat Enterprise Linux / Oracle Linux Fedora Linux - Generic Oracle Solaris macOS FreeBSD Source Code Select OS Version: All Wind

dev.mysql.com

๋งํฌ๋ฅผ ํƒ€๊ณ  ๋“ค์–ด๊ฐ„ ํ›„, ๋ณธ์ธ ์ปดํ“จํ„ฐ ์šด์˜์ฒด์ œ์— ๋งž๋Š” MySQL์„ ๋‹ค์šด๋ฐ›์Šต๋‹ˆ๋‹ค.

๋งจ ์œ„ ๋‹ค์šด๋กœ๋“œ ์„ ํƒ

 

MySQL 8.0.23 ๋ฒ„์ „์„ ๋‹ค์šด๋ฐ›์Šต๋‹ˆ๋‹ค.

3. Bitnami ์„ค์น˜

๊ณต์‹ ํ™ˆํŽ˜์ด์ง€ ์„ค์น˜ ๋ฐฉ์‹์ด ๊นŒ๋‹ค๋กญ๊ธฐ ๋•Œ๋ฌธ์— Bitnami WAMP๋ฅผ ์ด์šฉํ•ฉ๋‹ˆ๋‹ค.

WAMP : Window์—์„œ Apache์™€ MySQL, PHP๋ฅผ ๋™์‹œ์— ์„ค์น˜ํ•ด์ฃผ๋Š” ํ”„๋กœ๊ทธ๋žจ

 

bitnami.com/stack/wamp

 

WAMP

Bitnami WAMP Stack provides a complete, fully-integrated and ready to run WAMP development environment. In addition to PHP, MySQL and Apache, it includes FastCGI, OpenSSL, phpMyAdmin, ModSecurity, SQLite, ImageMagick, xDebug, Xcache, OpenLDAP, ModSecurity,

bitnami.com

๊ฐ€์ž…์—†์ด, ๋‹ค์šด๋กœ๋“œ๋ฅผ ๋ฐ›์•„์ค๋‹ˆ๋‹ค. No thanks

 

 


๐Ÿ‘ฉ‍๐Ÿ’ป ๋‹ค์šด๋กœ๋“œ ๋œ ์„ค์น˜ ํŒจํ‚ค์ง€๋ฅผ ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.

 

1. ์„ค์น˜ ๋„์ค‘ ๋œจ๋Š” ํ•˜๋‹จ ์ฒดํฌ๋ฐ•์Šค๋Š” ์›๋ž˜์ƒํƒœ๋กœ ๋‘๊ณ  NEXT 

 

2. ์„ค์น˜ ๊ฒฝ๋กœ ๊ธฐ์–ตํ•ด๋‘๊ธฐ

C:\Bitnami\wampstack-8.0.2-0

 

3. MySQL์˜ ๊ธฐ๋ณธ ์‚ฌ์šฉ์ž๋Š” root , ์ด ์‚ฌ์šฉ์ž์˜ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ์ง€์ •ํ•ด์ค๋‹ˆ๋‹ค.

 

4. PORT๋Š” ๊ทธ๋Œ€๋กœ ์œ ์ง€ (์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋‹ค๋ฉด ๋‹ค๋ฅธ ํฌํŠธ๋ฒˆํ˜ธ๋กœ ๋ฐ”๊ฟ”์ค๋‹ˆ๋‹ค.)

 

5. ์ฒดํฌ๋ฐ•์Šค ํ•ด์ œ

 

6. ๋‹ค์šด๋กœ๋“œ ์‹œ๊ฐ„์ด ๊ฝค ๊ฑธ๋ฆฝ๋‹ˆ๋‹ค. 

7. Apache ACCESS ์•Œ๋ฆผ ์ฐฝ์ด ๋œจ๋ฉด ์ ‘์†ํ—ˆ์šฉ!

8. Finish


9. ์„ค์น˜๋œ ๊ฒฝ๋กœ์— ๊ฐ€์„œ manager-windows ์‘์šฉ ํ”„๋กœ๊ทธ๋žจ ์‹คํ–‰

 

10. Manage Servers๋กœ ํƒญ ์ด๋™

 

11. ์ปดํ“จํ„ฐ ์žฌ๋ถ€ํŒ…์‹œ ๊บผ์ ธ์žˆ๋Š” ๊ฒฝ์šฐ, MySQL ์„œ๋ฒ„๋ฅผ Start๋ฅผ ๋ˆŒ๋Ÿฌ ์‹คํ–‰์‹œ์ผœ์ค๋‹ˆ๋‹ค.

์ดˆ๋ก์ƒ‰ : ์ผœ์ ธ์žˆ์Œ ๋นจ๊ฐ„์ƒ‰ : ๊บผ์ ธ์žˆ์Œ (Stop)

 

12. CMD์ฐฝ์„ ๋„์›๋‹ˆ๋‹ค. [์œˆ๋„์šฐํ‚ค] + [R] : ์‹คํ–‰ ์ฐฝ ๋„์šฐ๊ณ  CMD ์ž…๋ ฅ

 

13. CMD์ฐฝ์—์„œ MySQL์ด ์„ค์น˜๋œ ๊ฒฝ๋กœ์˜ mysql ํ•˜์œ„ bin ํด๋”๋กœ ์ด๋™

- cd ์ž…๋ ฅ ํ›„, ํƒ์ƒ‰ ์ฐฝ์˜ ์ฃผ์†Œ๋ฅผ ๋ณต์‚ฌ ๋ถ™์—ฌ๋„ฃ๊ธฐ 

- cd C:\Bitnami\wampstack-8.0.2-0\mysql\bin

- [์ฐธ๊ณ ] ์ง์ ‘์ž…๋ ฅํ• ๋•Œ๋Š” cd C:\Bit ๋“ฑ ์•ž๋ถ€๋ถ„์„ ์ž…๋ ฅํ•˜๊ณ  tabํ‚ค๋ฅผ ๋ˆ„๋ฅด๋ฉด ํ•ด๋‹น ํด๋”๋ช…์ด ์ž๋™ ์™„์„ฑ๋ฉ๋‹ˆ๋‹ค.

 

14. bin ํด๋” ๊ฒฝ๋กœ๊นŒ์ง€ ์„ค์ •๋˜๋ฉด mysql -uroot -p ๋ช…๋ น์–ด ์ž…๋ ฅ ํ›„, ์„ค์น˜ํ•  ๋•Œ ์„ค์ •ํ–ˆ๋˜ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ์ž…๋ ฅ

 

15. Welcome to the MySQL monitor. ์ด๋ผ๊ณ  ๋œจ๋ฉด ์ •์ƒ์ ์œผ๋กœ ์„ค์น˜ ์™„๋ฃŒ!

 

4. ์„ค์น˜์—†์ด ์‚ฌ์šฉํ•˜๊ธฐ

codeanywhere ์‚ฌ์ดํŠธ๋Š” ์‚ฌ์šฉํ•˜๋Š” ํ”„๋กœ๊ทธ๋žจ, ๊ธฐ์ˆ ์— ๋งž๋Š” ์„ค์ •์„ ์ž๋™์œผ๋กœ ์„ธํŒ…ํ•ฉ๋‹ˆ๋‹ค.

์›น ์ƒ์— ์ผ์ข…์˜ ์ปดํ“จํ„ฐ๋ฅผ ์ƒˆ๋กœ ์„ธํŒ…ํ•ด์ฃผ๋Š” ๋Š๋‚Œ!

๋ฌด๋ฃŒ๊ณ„์ •์€ ํ•˜๋ฃจ์— 2์‹œ๊ฐ„๋งŒ ์ด์šฉํ•  ์ˆ˜ ์žˆ๋Š” ๋“ฏ.....๐Ÿ˜…

 

https://codeanywhere.com/

 

Codeanywhere - Cross Platform Cloud IDE

Terminal Terminal Lastly, our fully featured web based terminal enables you to run commands, debug your applications and display command output from your servers. Execute Git commands, or use a source version control system of your choice. Compile your cod

codeanywhere.com

1. ์‚ฌ์ดํŠธ ํšŒ์›๊ฐ€์ž… ํ›„, Editor๋ฅผ ํ‚ค๋ฉด ์ž๋™์œผ๋กœ ํŒ์—…์ด ๋œน๋‹ˆ๋‹ค.

mysql์„ ๊ฒ€์ƒ‰ํ•˜๊ณ  ์›ํ•˜๋Š” ์„ค์ •์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค. ์ƒํ™œ์ฝ”๋”ฉ์—์„œ๋Š” PHP 7๋ฅผ ์„ ํƒ ํ›„, Create ๋ฒ„ํŠผ ํด๋ฆญ

(์ƒ์„ฑ ์‹œ๊ฐ„ ๊ฑธ๋ฆฝ๋‹ˆ๋‹ค.)

ํ•ด๋‹น ํŒ์—…์ฐฝ์ด ๋œจ์ง€ ์•Š์„๊ฒฝ์šฐ File > New Connection > Container๋กœ ์—ด ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

2. SSH ํ„ฐ๋ฏธ๋„ ์—ด๊ธฐ

3. SSH ํ„ฐ๋ฏธ๋„์—์„œ mysql์„ ์‚ฌ์šฉํ•˜๊ธฐ ์œ„ํ•ด ๋ช…๋ น์–ด ์ž…๋ ฅ mysql -uroot

; mysql์„ ์‚ฌ์šฉํ•  ๊ฒƒ์ด๋ฉฐ ์•„์ด๋””๋Š” root ์ด๋‹ค. ( root : ๊ด€๋ฆฌ์ž )

4. ๋ช…๋ น์–ด ์ž…๋ ฅ ํ›„, mysql > ๊ฐ€ ๋‚˜์™€์•ผ ํ•จ [์™„๋ฃŒ]

 

 

์ฐธ๊ณ  : ์œ ํˆฌ๋ธŒ ์ƒํ™œ์ฝ”๋”ฉ mysql

www.youtube.com/playlist?list=PLuHgQVnccGMCgrP_9HL3dAcvdt8qOZxjW

728x90