๐Ÿ“–
Mini's Today I Learned
  • Today I Learned
  • ๐Ÿ’ปComputer Science
    • ๐ŸงฑComputer Science
      • Computer Architecture
    • ๐Ÿฆ•OperatingSystem
      • System Structure
      • 01. ์šด์˜์ฒด์ œ ์—ญํ• 
      • 02. History๋กœ ์ดํ•ดํ•˜๋Š” ์šด์˜์ฒด์ œ
      • 03. ์šด์˜์ฒด์ œ ๊ตฌ์กฐ
      • 04. ํ”„๋กœ์„ธ์Šค ์Šค์ผ€์ฅด๋ง
      • 05. ์Šค์ผ€์ฅด๋ง ์•Œ๊ณ ๋ฆฌ์ฆ˜
      • 06. ํ”„๋กœ์„ธ์Šค ์ƒํƒœ์™€ ์Šค์ผ€์ฅด๋Ÿฌ
      • 07. ์ธํ„ฐ๋ŸฝํŠธ
      • 08. ํ”„๋กœ์„ธ์Šค์™€ ์ปจํ…์ŠคํŠธ ์Šค์œ„์นญ
      • 09. ํ”„๋กœ์„ธ์Šค๊ฐ„ ์ปค๋ฎค๋‹ˆ์ผ€์ด์…˜(IPC ๊ธฐ๋ฒ•)
      • 10. Thread(์Šค๋ ˆ๋“œ)
      • 11. ๊ฐ€์ƒ๋ฉ”๋ชจ๋ฆฌ (Virtual Memory System)
      • 12. ํŒŒ์ผ์‹œ์Šคํ…œ ์ดํ•ด
      • 13. ๋ถ€ํŒ…์˜ ์ดํ•ด
      • 14. ๊ฐ€์ƒ๋จธ์‹ (Virtual Machine)
  • ๐Ÿ“ˆDatabase
    • MySQL CLI (Frequently used)
    • 1-Tier, 2Tier, 3Tier
    • Basic SQL
    • Built in function
    • Sub Query
    • View
    • Stored Program
    • index
    • Normalization(์ •๊ทœํ™”)
    • Transaction
    • Transaction
  • ๐ŸŒ Network
    • ๐Ÿ”Œ TCP&IP Basic
      • 01 TCP/IP ๋ง›๋ณด๊ธฐ
      • 02 TCP/IP ๊ฐœ์š”
      • 03 ํ†ต์‹  ์„œ๋น„์Šค์™€ ํ”„๋กœํ† ์ฝœ
      • 04 ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๊ณ„์ธต
      • 05 ํŠธ๋ Œ์ŠคํฌํŠธ ๊ณ„์ธต
      • 06 ๋„คํŠธ์›Œํฌ๊ณ„์ธต
      • 07 ๋ฐ์ดํ„ฐ ๊ณ„์ธต๊ณผ ๋ฌผ๋ฆฌ๊ณ„์ธต
      • 08 ๋ผ์šฐํŒ…
      • 09 ๋ณด์•ˆ
      • 10 HTTP ํ”„๋กœํ† ์ฝœ
    • ๐Ÿฟ๏ธHTTP ์™„๋ฒฝ ๊ฐ€์ด๋“œ ์š”์•ฝ
      • 1. HTTP: ์›น์˜ ๊ธฐ์ดˆ
      • 2. URL ๊ณผ ๋ฆฌ์†Œ์Šค
      • 3. HTTP Message
      • 4. Connection Management
      • 5. Overview of web server architectures
      • 6. Proxies
      • 7.Caching
      • 8. Integration Points: Gateways, Tunnels, and Relays
      • 9. Web Robots
      • 10. HTTP/2.0
      • 11. Client Identification and Cookies
      • 12. Basic Authentication
      • 13. Digest Authentication
      • 14. Secure HTTP
      • 15. Entities and Encodings
      • 16. Internationalization
      • 17. Content Negotiation and Transcoding
      • 18. Web Hosting
  • ๐ŸดLanguage
    • โ˜•JAVA
      • Comparable vs Comparator
  • ๐Ÿ› ๏ธ Framework
  • ๐ŸงฉDesign Pattern
    • ๊ฐ์ฒด ์ง€ํ–ฅ ์„ค๊ณ„ ์›์น™ (SOLID)
    • Design Pattern ๊ฐœ์š”
    • Template method
    • Singleton
  • ๐ŸฅFrontEnd
    • HTML&CSS
      • 01 Intro
      • 02 HTML Basic
      • 03 Content Section
      • 04 Block and Inline Elements
      • 05 Text Contents
      • 06 Inline Elements
      • 07 Multi Media
      • 08 Table&Form&etc
      • 09 Global Attribute & etc
      • 10 css basic
      • 11 css config
      • 12 css unit
      • 13 Box Model
      • 14 Font & Text
      • 15 Float(๋„์›€) & Position
      • 16 Background
      • 17 Transitions & Transforms
      • 18 Animation & Multi Columns(๋‹ค๋‹จ)
      • 19 Flex
      • 20 Grid
    • Sass(SCSS)
    • TypeScript
    • Webpack Introduction
      • ์›นํŒฉ์˜ ๊ธฐ๋ณธ ๊ตฌ์กฐ
      • CommonJS
      • ESM
      • WebpackConfig
        • 1. Handlebars
        • 2. Caching
        • 3. Minification & Mangling
        • 4. Mode(Development mode & Production Mode)
        • 5. ์ด๋ฏธ์ง€ ํŒŒ์ผ ๋ชจ๋“ˆ๋กœ ๋‹ค๋ฃจ์–ด๋ณด๊ธฐ(file-loader)
        • 6. ์ด๋ฏธ์ง€ ํŒŒ์ผ ๋ชจ๋“ˆ๋กœ ๋‹ค๋ฃจ์–ด๋ณด๊ธฐ(url-loader)
        • 7. SASS Loader
        • 8. Post CSS
        • 9. BLOWSERS LIST
        • 10. Stylelint
        • 11. Babel
      • Webpack-Practice
    • ETC
      • GIT
      • MarkDown
Powered by GitBook
On this page
  • ์‚ฌ์šฉ์ž ๋ชฉ๋ก, ์ถ”๊ฐ€ , ์ œ๊ฑฐ ๊ถŒํ•œ ๋ถ€์—ฌ
  • DATABASE ์ƒ์„ฑ, ๋ชฉ๋ก, ๋ณด๊ธฐ
  • Windows์—์„œ Database ๊ด€๋ฆฌ

Was this helpful?

  1. Database

MySQL CLI (Frequently used)

์‚ฌ์šฉ์ž ๋ชฉ๋ก, ์ถ”๊ฐ€ , ์ œ๊ฑฐ ๊ถŒํ•œ ๋ถ€์—ฌ

๊ธฐ๋Šฅ

๋ช…๋ น์–ด

์‚ฌ์šฉ์˜ˆ

์„œ๋ฒ„ ๋กœ๊ทธ์ธ (MySQL์ ‘์†)

mysql -u [username] -p;

โ€ข mysql โ€“u root โ€“p; โ€ข password์ž…๋ ฅ

์‚ฌ์šฉ์ž ๋ชฉ๋ก ์กฐํšŒ

use mysql; select user, host from user;

โ€ขmysql๊ธฐ๋ณธ ์Šคํ‚ค๋งˆ mysql์•ˆ์— โ€ขmysql ๊ธฐ๋ณธ์Šคํ‚ค๋งˆ์ธ user table์—์„œ ํ™•์ธ๊ฐ€๋Šฅ.

์‚ฌ์šฉ์ž ์ถ”๊ฐ€

create user {username}@{ip} identified by '{password}';

โ€ขcreate user bit@localhost identified by 'bit'; โ€ขcreate user bit@123.456.% identified by 'bit';

์‚ฌ์šฉ์ž ์ œ๊ฑฐ

drop user {username}; drop user 'user'@'localhost';delete from user where user={username};

โ€ขdrop ์ถ”์ฒœ

๊ถŒํ•œ ํ™•์ธ

show grants for {username}@{ip};

โ€ข show grants for bit@localhost;

๊ถŒํ•œ ๋ถ€์—ฌ

grant {๊ถŒํ•œ} privileges on {์Šคํ‚ค๋งˆ}.{ํ…Œ์ด๋ธ”} to {username}@{ip};

โ€ข grant all privileges on *.* to bit@localhost;

๊ถŒํ•œ ์ œ๊ฑฐ

revoke {๊ถŒํ•œ} privileges on {์Šคํ‚ค๋งˆ}.{ํ…Œ์ด๋ธ”} from {username}@{ip};

โ€ข revoke all on bit.* from bit@localhost;

์‚ฌ์šฉ์ž ์ „ํ™˜

system mysql -u [์‚ฌ์šฉ์ž๋ช…] -p [password]

system mysql -u madang -p madang

DATABASE ์ƒ์„ฑ, ๋ชฉ๋ก, ๋ณด๊ธฐ

๊ธฐ๋Šฅ

๋ช…๋ น์–ด

์‚ฌ์šฉ ์˜ˆ

๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ƒ์„ฑ

create database [database];

โ€ข database ์ƒ์„ฑ

๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ ํƒ

use [database];

โ€ข database ์„ ํƒ

๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ณด๊ธฐ

show databases;

โ€ข database ์–ด๋–ค ๊ฒŒ ์žˆ๋Š”์ง€ ๋ณด์—ฌ์คŒ

ํ…Œ์ด๋ธ” ๋ณด๊ธฐ

show tables;

โ€ข database ์— ์žˆ๋Š” ํ…Œ์ด๋ธ” ๋ณด์—ฌ์ค€๋‹ค.

Windows์—์„œ Database ๊ด€๋ฆฌ

  • windows์šฉ MySQL์€ windows ์žฌ ๋ถ€ํŒ…์‹œ ์ž๋™ ์‹คํ–‰ ๋œ๋‹ค. ์œˆ๋„์šฐ ์„œ๋น„์Šค๋ฅผ ํ†ตํ•ด ๊ด€๋ฆฌ

  • ์œˆ๋„์šฐ ๊ฒ€์ƒ‰ ์ฐฝ์—์„œ๋Š” services

  • ์‹คํ–‰์ฐฝ (window + R) ์—์„œ๋Š” services.msc ์ž…๋ ฅ.

  • ๋‚˜์˜ ๊ฒฝ์šฐ ํ•˜๋ฃจ ํ•˜๋ฃจ ์ข…์ผ ์“ฐ์ง€ ์•Š๊ธฐ ๋•Œ๋ฌธ์—, ๋ถ€ํŒ… ์‹œ ์ˆ˜๋™์œผ๋กœ ์ผค ์ˆ˜ ์žˆ๋„๋ก ํ–ˆ๋‹ค.

PreviousDatabaseNext1-Tier, 2Tier, 3Tier

Last updated 4 years ago

Was this helpful?

๐Ÿ“ˆ