๐Ÿ“ Back-end & ๐Ÿ‘ฉ๐Ÿปโ€๐Ÿ’ป

๐Ÿ“ Back-end & ๐Ÿ‘ฉ๐Ÿปโ€๐Ÿ’ป/Database

[DB] SQL&Database ๋๋‚ด๊ธฐ - DBeaver ์„ค์น˜ ๋ฐ MySQL ์—ฐ๋™ with Mac (1)

MySQL ์„ค์น˜์ฐธ๊ณ : 2024.07.02 - [๐Ÿ“ Back-end & ๐Ÿ‘ฉ๐Ÿปโ€๐Ÿ’ป/Modeling & SQL] - [DB] Mac์— MySQL ์„ค์น˜ (Community Server, WorkBench) #0$ brew install mysql@8.3$ open ~/.zshrc  - ๋„ฃ๊ธฐ: export PATH="$PATH:/usr/local/mysql/bin:/" $ mysql -u root -p  DBeaver ์„ค์น˜https://dbeaver.io/download/ Download | DBeaver CommunityDownload DBeaver Community 24.3 Released on December 2nd 2024 (Milestones). It is free and open source (..

๐Ÿ“ Back-end & ๐Ÿ‘ฉ๐Ÿปโ€๐Ÿ’ป/Database

[RDBMS] MySQL ํ„ฐ๋ฏธ๋„๋กœ ์ ‘์†ํ•˜๊ธฐ, ๋น„๋ฐ€๋ฒˆํ˜ธ ๋ณ€๊ฒฝ

ํ„ฐ๋ฏธ๋„๋กœ MySQL ์ ‘์†์„ค์น˜ ๊ฒฝ๋กœ๋กœ ์ด๋™ํ•˜๊ธฐ$ cd /usr/local/mysql/binMySQL root๋กœ ์ ‘์†ํ•˜๊ธฐ$ ./mysql -u root -p๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅํ•˜๊ณ  enter๋ฅผ ๋ˆ„๋ฅด๋ฉด mysql์— ์ ‘์†๋œ ๊ฑธ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.  MySQL ๋น„๋ฐ€๋ฒˆํ˜ธ ๋ณ€๊ฒฝ์œ„ ๊ทธ๋ฆผ์ฒ˜๋Ÿผ MySQL์— ์ ‘์†ํ–ˆ๋‹ค๋ฉด ์•„๋ž˜์˜ ๋ช…๋ น์–ด๋ฅผ ์ž…๋ ฅํ•˜์—ฌ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ๋ณ€๊ฒฝํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.โ€ป ์‚ฌ์šฉ์ž ์ด๋ฆ„์„ root๋กœ ๊ฐ€์ •ํ–ˆ์ง€๋งŒ, ๋‹ค๋ฅธ ์‚ฌ์šฉ์ž ์ด๋ฆ„์„ ์‚ฌ์šฉํ•œ๋‹ค๋ฉด root ๋ถ€๋ถ„์„ ํ•ด๋‹น ์‚ฌ์šฉ์ž ์ด๋ฆ„์œผ๋กœ ๋ฐ”๊พธ์–ด์ฃผ์„ธ์š”. $ ALTER USER 'root'@'localhost' IDENTIFIED BY '์ƒˆ๋กœ์šด_๋น„๋ฐ€๋ฒˆํ˜ธ';$ FLUSH PRIVILEGES; ์ดํ›„ MySQL์„ ๋‚˜๊ฐ‘๋‹ˆ๋‹ค.$ exit  ๋‹ค์‹œ MySQL๋กœ ์ ‘์†ํ•˜๊ณ , ๋ณ€๊ฒฝํ•œ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ์ž…๋ ฅํ•˜๋ฉด ํ™•์ธ..

๐Ÿ“ Back-end & ๐Ÿ‘ฉ๐Ÿปโ€๐Ÿ’ป/Database

[Graph DB] Neo4j web test

๋ณดํ˜ธ๋˜์–ด ์žˆ๋Š” ๊ธ€์ž…๋‹ˆ๋‹ค.

๐Ÿ“ Back-end & ๐Ÿ‘ฉ๐Ÿปโ€๐Ÿ’ป/Docker

[Docker] ๋ฆฌ๋ˆ…์Šค ๋„์ปค(docker) ๋ฐ ๋„์ปค ์ปดํฌ์ฆˆ(docker-compose) ์„ค์น˜

์„ค์น˜๋Š” ๊ณต์‹ ํ™ˆํŽ˜์ด์ง€์˜ ๋ช…๋ น์–ด๋ฅผ ์ž…๋ ฅํ•˜๋Š” ๊ฒƒ์ด ๊ฐ€์žฅ ์•ˆ์ „ํ•ฉ๋‹ˆ๋‹ค. (์ตœ์‹  ๋ฒ„์ „) ๋„์ปค(docker) ์„ค์น˜ https://docs.docker.com/engine/install/ubuntu/ UbuntuJumpstart your client-side server applications with Docker Engine on Ubuntu. This guide details prerequisites and multiple methods to install Docker Engine on Ubuntu.docs.docker.com 1. ์„ค์น˜ ๋ช…๋ น์–ด ๋ชจ๋‘ ์ž…๋ ฅ   2. sudo ์—†์ด docker ๋ช…๋ น์–ด (ํŽธ๋ฆฌ๋ฅผ ์œ„ํ•ด ..!!! ์„ ํƒ์ž…๋‹ˆ๋‹ค) - ๊ด€๋ฆฌ์ž ๊ถŒํ•œ์„ ์ฃผ๋ฉด๋ฉ๋‹ˆ๋‹ค.sudo usermod -aG docker {use..

๐Ÿ“ Back-end & ๐Ÿ‘ฉ๐Ÿปโ€๐Ÿ’ป/Database

[RDBMS] MySQL Workbench์— DB์ƒ์„ฑ

+ ๋ฒ„ํŠผ ๋ˆŒ๋Ÿฌ์„œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ƒ์„ฑ createํ•ด์„œ ํ…Œ์ด๋ธ” ๋งŒ๋“ค๊ธฐ schemas์—์„œ ํ…Œ์ด๋ธ”์„ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. [์˜ˆ์‹œ] 1) test ์Šคํ‚ค๋งˆ๋ฅผ ๋งŒ๋“ญ๋‹ˆ๋‹ค.create database test 2) member ํ…Œ์ด๋ธ”์„ ๋งŒ๋“ญ๋‹ˆ๋‹ค.CREATE TABLE member ( member_id VARCHAR(20) NOT NULL UNIQUE CHECK (member_id REGEXP '^[A-Za-z0-9]+$'), -- ์˜๋ฌธ, ์ˆซ์ž๋งŒ ๊ฐ€๋Šฅ password VARCHAR(20) NOT NULL UNIQUE CHECK (password REGEXP '^[A-Za-z0-9]+$'), -- ์˜๋ฌธ, ์ˆซ์ž๋งŒ ๊ฐ€๋Šฅ member_name VARCHAR(50) NOT NULL, -- ํšŒ์›์ด๋ฆ„ email VARCHA..

๐Ÿ“ Back-end & ๐Ÿ‘ฉ๐Ÿปโ€๐Ÿ’ป/Database

[Graph DB] ์šฐ๋ถ„ํˆฌ(Ubuntu)์— Neo4j & Neo4j Desktop ์„ค์น˜ํ•˜๊ธฐ

Neo4jJDK17 ์„ค์น˜$ sudo apt-get update && sudo apt-get upgrade -y$ sudo apt install openjdk-17-jdk$ java -version Neo4j ๊ด€๋ จ ์„ค์น˜$ sudo apt-get update && sudo apt-get upgrade -y$ sudo apt-get install wget curl nano software-properties-common dirmngr apt-transport-https gnupg gnupg2 ca-certificates lsb-release ubuntu-keyring unzip -y$ curl -fsSL https://debian.neo4j.com/neotechnology.gpg.key | sudo gpg -..

์ƒ๋‹จ์œผ๋กœ

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”