๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ


๐Ÿ’ป

(8)
mysql 2. Access Denied ์˜ค๋ฅ˜ ํ•ด๊ฒฐ ์œ„์™€ ๊ฐ™์€ ๋ช…๋ น์–ด๋กœ ๋ฐ์ดํ„ฐ ์ด๊ด€์„ ์‹œ๋„ํ–ˆ์œผ๋‚˜ ๊ถŒํ•œ๋ฌธ์ œ๋•Œ๋ฌธ์— ๋‹ค์Œ๊ณผ ๊ฐ™์€ ์˜ค๋ฅ˜๊ฐ€ ์ถœ๋ ฅ๋˜์—ˆ๋‹ค. Access denied; you need (at least one of) the SUPER privilege(s) for this operation AWS RDS ์ง€์นจ์„œ์— ๋”ฐ๋ฅด๋ฉด ๋‹ค์Œ๊ณผ ๊ฐ™์€ ์ด์œ ๋•Œ๋ฌธ์— ์—‘์„ธ์Šค ๊ฑฐ๋ถ€ ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ•œ๋‹ค๊ณ  ํ•œ๋‹ค. ๋Œ€์ƒ RDS ์ธ์Šคํ„ด์Šค์— ์ด์ง„ ๋กœ๊ทธ๊ฐ€ ํ™œ์„ฑํ™”([๋ฐฑ์—… ๋ณด์กด ๊ธฐ๊ฐ„] > 0)๋˜์–ด ์žˆ์œผ๋ฉฐ, mysqldump ํŒŒ์ผ์ด ํŠธ๋ฆฌ๊ฑฐ, ๋ทฐ, ํ•จ์ˆ˜ ๋˜๋Š” ์ด๋ฒคํŠธ์™€ ๊ฐ™์€ ๊ฐ์ฒด๋ฅผ ํฌํ•จ ๊ฐ€์ ธ์˜จ mysqldump ํŒŒ์ผ์ด DB ์ธ์Šคํ„ด์Šค์— ์กด์žฌํ•˜์ง€ ์•Š๋Š” DEFINER ์†์„ฑ ์‚ฌ์šฉ์ž๋กœ ๊ฐ์ฒด๋ฅผ ์ƒ์„ฑํ•˜๋ ค๊ณ  ์‹œ๋„ํ–ˆ๊ฑฐ๋‚˜ ์‚ฌ์šฉ์ž๊ฐ€ ํ•„์š”ํ•œ SUPER ์‚ฌ์šฉ์ž ๊ถŒํ•œ์„ ๊ฐ€์ง€๊ณ  ์žˆ์ง€ ์•Š์€..
์œˆ๋„์šฐ10์—์„œ SSH ์ ‘์† ์‹œ pem ํŒŒ์ผ ๊ถŒํ•œ๋ณ€๊ฒฝ cd c:/Windows/System32 icacls.exe d:/j.pem /reset icacls.exe d:/j.pem /grant:r %username%:(R) icacls.exe d:/j.pem /inheritance:r https://taehyeki.tistory.com/224 ์œˆ๋„์šฐ10์—์„œ SSH ์ ‘์† ์‹œ pem ํŒŒ์ผ ๊ถŒํ•œ๋ณ€๊ฒฝ EC2 ์ธ์Šคํ„ด์Šค๋ฅผ SSH๋กœ ์ ‘์†ํ•˜๊ณ  ์‹ถ์„ ๋•Œ๋Š”, pem ํŒŒ์ผ์„ ํ™œ์šฉํ•ด์•ผ ํ•œ๋‹ค. ๊ทธ๋Ÿฐ๋ฐ ๋ณด์•ˆํŠน์„ฑ ์ƒ AWS ํ™ˆํŽ˜์ด์ง€์—์„œ ๋‹ค์šด๋ฐ›์€ pem ํŒŒ์ผ์„ ๊ทธ๋Œ€๋กœ ์‚ฌ์šฉํ•˜๋ฉด permission ์—๋Ÿฌ๊ฐ€ ๋‚œ๋‹ค. ํŒŒ์ผ ์ž์ฒด์— ๊ถŒํ•œ์ด ๋„ˆ๋ฌด ๋งŽ taehyeki.tistory.com
[AWS] bookmarks https://inpa.tistory.com/entry/AWS-%F0%9F%93%9A-Lightsail-vs-EC2-%EB%B9%84%EA%B5%90-%EC%96%B4%EB%8A%90%EA%B2%8C-%EC%A2%8B%EC%9D%84%EA%B9%8C?category=947448 [AWS] ๐Ÿ“š Lightsail vs EC2 ๋น„๊ต - ์–ด๋Š๊ฒŒ ์ข‹์„๊นŒ? EC2 vs Lightsail ๋น„๊ต AWS์—์„œ๋Š” ์›น์„œ๋น„์Šค ํ˜ธ์ŠคํŒ…์„ ์œ„ํ•ด EC2์™€ Lightsail ๊ฐ€์ƒ ์„œ๋ฒ„ ์„œ๋น„์Šค๋ฅผ ์ œ๊ณตํ•œ๋‹ค. ๋‘˜ ๋‹ค ์ธ์Šคํ„ด์Šค๋ฅผ ์ƒ์„ฑํ•ด์„œ ์„œ๋น„์Šค๋ฅผ ์˜ฌ๋ ค๋ด๋„ ์–ด๋–ค๊ฒŒ ๋‚ด ์ƒํ™ฉ์— ๋งž๋Š” ์„œ๋น„์Šค์ธ์ง€ ์ž˜ ํ™•์‹ ์ด ์„œ inpa.tistory.com
AWS EC2 ์ธ์Šคํ„ด์Šค ์‹œ์ž‘ ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๋ฐ OS ์ด๋ฏธ์ง€ Amazon Linux 2 AMI (HVM) - Kernel 5.10, SSD Volumne Type (ํ”„๋ฆฌํ‹ฐ์–ด ์‚ฌ์šฉ ๊ฐ€๋Šฅ) ์„ ํƒ ์ธ์Šคํ„ด์Šค ์œ ํ˜• t2.micro ํ‚ค ํŽ˜์–ด ์ƒ์„ฑ ์ƒˆ ํ‚ค ํŽ˜์–ด ์ƒ์„ฑ, pem ํŒŒ์ผ ๋‹ค์šด๋กœ๋“œ ๋„คํŠธ์›Œํฌ ์„ค์ • ์—์„œ SSH ํŠธ๋ž˜ํ”ฝ ํ—ˆ์šฉ -> ๋‚ด IP ์ธ์Šคํ„ด์Šค ์‹œ์ž‘! pem ํŒŒ์ผ ์˜ค๋ฅ˜...์ฐธ๊ณ  https://techsoda.net/windows10-pem-file-permission-settings/ ์œˆ๋„์šฐ10 SSH ์ ‘์†์‹œ PEM ํŒŒ์ผ ํผ๋ฏธ์…˜ ์—๋Ÿฌ ํ•ด๊ฒฐ๋ฐฉ๋ฒ• - ํ…Œํฌ์†Œ๋‹ค ์ด ๊ธ€์€ ์œˆ๋„์šฐ10์—์„œ BASH, WSL, ํŒŒ์›Œ์‰˜์„ ํ†ตํ•ด SSH ์ ‘์†์‹œ PEM ํŒŒ์ผ ํผ๋ฏธ์…˜ ์—๋Ÿฌ๊ฐ€ ๋‚ ๋•Œ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด์„œ ๋‹ค๋ฃจ๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค. ์œˆ๋„์šฐ10์—์„œ OpenSSH..
Azure ๊ฐ€์ƒ๋จธ์‹  ๋ฆฌ๋ˆ…์Šค SSH https://docs.microsoft.com/ko-kr/azure/virtual-machines/linux/quick-create-portal ๋น ๋ฅธ ์‹œ์ž‘ - Azure Portal์—์„œ Linux VM ๋งŒ๋“ค๊ธฐ - Azure Virtual Machines ์ด ๋น ๋ฅธ ์‹œ์ž‘์—์„œ๋Š” Azure Portal์„ ์‚ฌ์šฉํ•˜์—ฌ Linux ๊ฐ€์ƒ ๋จธ์‹ ์„ ๋งŒ๋“œ๋Š” ๋ฐฉ๋ฒ•์„ ๋ฐฐ์›๋‹ˆ๋‹ค. docs.microsoft.com ์—ฐ์Šต - SSH์— ๋Œ€ํ•œ ์ธ์ฆ ๋ฐฉ๋ฒ• ๊ฒฐ์ • https://docs.microsoft.com/ko-kr/learn/modules/create-linux-virtual-machine-in-azure/3-exercise-generate-ssh-key ์—ฐ์Šต - SSH์— ๋Œ€ํ•œ ์ธ์ฆ ๋ฐฉ๋ฒ• ๊ฒฐ์ • - Learn SSH์— ๋Œ€ํ•œ ์ธ์ฆ ๋ฐฉ๋ฒ• ..
ํด๋ผ์šฐ๋“œ https://www.vultr.com/ SSD VPS Servers, Cloud Servers and Cloud Hosting by Vultr Vultr Global Cloud Hosting - Brilliantly Fast SSD VPS Cloud Servers. 100% KVM Virtualization www.vultr.com https://www.linode.com/ko/ Linode | ๊ฐœ๋ฐœ์ž๋“ค์„ ์œ„ํ•œ ๋…๋ฆฝ ์˜คํ”ˆ ํด๋ผ์šฐ๋“œ ์šฐ๋ฆฌ ์ž„๋ฌด๋Š” ํด๋ผ์šฐ๋“œ ์ปดํ“จํŒ…์„ ๋ชจ๋‘์—๊ฒŒ ํ•ฉ๋ฆฌ์ ์ธ ๊ฐ€๊ฒฉ์œผ๋กœ ๊ฐ„๋‹จํ•˜๋ฉฐ ์ ‘๊ทผ์„ฑ์ด ์šฉ์ดํ•˜๋„๋ก ํ•˜์—ฌ ํ˜์‹ ์„ ๊ฐ€์†ํ™”ํ•˜๋Š” ๊ฒƒ์ž…๋‹ˆ๋‹ค. www.linode.com
WSL 2 ๋กœ ๋ณ€๊ฒฝ ๊ธฐ์กด ์šฐ๋ถ„ํˆฌ๊ฐ€ ์„ค์น˜ ๋˜์žˆ๋Š”๋ฐ WSL 1 ์ด๋ผ์„œ WSL 2๋กœ ๋ณ€๊ฒฝํ•จ WSL 2๋ฅผ ๊ธฐ๋ณธ์œผ๋กœ ์„ค์ • wsl --set-default-version 2 ์ฐธ์กฐ ์‚ฌ์ดํŠธ www.lesstif.com/software-architect/wsl-2-windows-subsystem-for-linux-2-preview-71401661.html WSL 2(Windows Subsystem For Linux 2) Preview ๋ฒ„์ „ ์‚ฌ์šฉํ•˜๊ธฐ Distro ์ด๋ฆ„์ด ์ž˜๋ชป ๋์„ ๊ฒฝ์šฐ "์ œ๊ณต ๋œ ์ด๋ฆ„ ์‚ฌ์šฉ ํ•˜ ์—ฌ ๋ฐฐํฌ ํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค." ์™€ ๊ฐ™์€ ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ•ฉ๋‹ˆ๋‹ค. ์˜ˆ๋กœ Ubuntu-18.04 ๋ฅผ ์‚ฌ์šฉํ•˜๋Š” ๊ฒฝ์šฐ Distro ์ด๋ฆ„์— "Ubuntu-18.04" ๋ฅผ ๋„ฃ์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. www.lesstif.com
Windows Terminal ์„ค์น˜, ์„ค์ • ํ•˜๊ธฐ ์œˆ๋„์šฐ์ฆˆ ํ„ฐ๋ฏธ๋„์ด๋ž€? docs.microsoft.com/ko-kr/windows/terminal/ Windows ํ„ฐ๋ฏธ๋„ ๊ฐœ์š” Windows ํ„ฐ๋ฏธ๋„ ๋ฐ ๋ช…๋ น์ค„ ์›Œํฌํ”Œ๋กœ๋ฅผ ๊ฐœ์„ ํ•  ์ˆ˜ ์žˆ๋Š” ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด ์•Œ์•„๋ด…๋‹ˆ๋‹ค. docs.microsoft.com ์„ค์น˜ microsoft store์—์„œ ์„ค์น˜ํ•œ๋‹ค www.microsoft.com/ko-kr/p/windows-terminal/9n0dx20hk701?rtc=1&activetab=pivot:overviewtab Windows Terminal ๊ตฌ๋งค - Microsoft Store ko-KR Microsoft Store์—์„œ ์ด Windows 10์šฉ ์•ฑ์„ ๋‹ค์šด๋กœ๋“œํ•˜์„ธ์š”. ์Šคํฌ๋ฆฐ์ƒท์„ ๋ณด๊ณ , ์ตœ์‹  ๊ณ ๊ฐ ๋ฆฌ๋ทฐ๋ฅผ ์ฝ๊ณ , Windows Terminal์— ๋Œ€ํ•œ ํ‰์ ์„ ๋น„๊ตํ•˜์„ธ์š”. ww..