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

IT-Engineering130

mysql Error: Access denied for user 'root'@'localhost' ์™„์ „ ํ•ด๊ฒฐ ์•„๋ž˜์˜ ์ƒํ™ฉ์€ mysql_secure_installation์„ ํ•˜๋“ , mysql -u root๋ฅผ ํ•˜๋“  mysql -u root -p๋ฅผ ํ•˜๋“  ๊ณ„์†๋ฐœ์ƒํ•˜๋Š” ์š”์ƒํ•œ ๋ฌธ์ œ์˜€๋‹ค. ํ•˜์ง€๋งŒ ๋๋‚ด ์ด ์ƒํ™ฉ์„ ์™„์ „ํ•˜๊ฒŒ ํ•ด๊ฒฐํ–ˆ๋‹ค. ~$ mysql_secure_installation Securing the MySQL server deployment. Enter password for user root: Error: Access denied for user 'root'@'localhost' ์ฐธ๊ณ ๋กœ ๋‚˜๋Š” Ubuntu18์—์„œ ์‹คํ–‰ํ–ˆ๋‹ค. ๊ทธ๋ฆฌ๊ณ  mysql์˜ ์‚ญ์ œ/์žฌ์„ค์น˜๋Š” ์•„๋ž˜์˜ ๊ธ€์„ ์ฐธ๊ณ ํ•˜์ž. https://gentlesark.tistory.com/158 ์šฐ๋ถ„ํˆฌ Ubuntu 18.04์—์„œ mysql5.7 ์™„์ „ ์‚ญ์ œ ๋ฐ ์žฌ์„ค์น˜ my.. 2023. 8. 23.
์šฐ๋ถ„ํˆฌ Ubuntu 18.04์—์„œ mysql5.7 ์™„์ „ ์‚ญ์ œ ๋ฐ ์žฌ์„ค์น˜ mysql5.7 ์™„์ „ ์‚ญ์ œ ๋‚ด ๊ฒฝ์šฐ ํŒจํ‚ค์ง€ ์„ค์น˜๋กœ ์ง„ํ–‰ํ–ˆ์—ˆ๊ธฐ์— ์•„๋ž˜์™€ ๊ฐ™์ด ๋ช…๋ น์–ด ์ž…๋ ฅ sudo apt-get remove --purge mysql* ํŒŒ์ผ๋“ค ์ „๋ถ€ ์‚ญ์ œ sudo rm -rf /etc/mysql /var/lib/mysql sudo rm -rf /var/log/mysql sudo rm -rf /var/log/mysql.* ์•„๋ž˜์˜ ๋ช…๋ น์–ด๋กœ ํ™•์ธ์‚ฌ์‚ด sudo apt-get autoremove ์ด๊ฒƒ๋„ sudo apt-get autoclean mysql5.7 ์žฌ์„ค์น˜ sudo apt-get install mysql-server --fix-missing --fix-broken sudo mysql_secure_installation 2023. 8. 23.
Mac OS Monterey(๋ฒ„์ „ 12.6)์—์„œ mysql 5.7 ์„ค์น˜ํ•˜๊ธฐ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋Š” ๋งฅ ๋ฒ„์ „ mysql ์„ค์น˜๋ฅผ ์œ„ํ•ด Homebrew๋ฅผ ํ™œ์šฉํ•˜์˜€์œผ๋ฉฐ, ์ด์™€ ๊ด€๋ จํ•ด์„œ๋Š” ์•„๋ž˜ ๊ธ€ ์ฐธ์กฐ. https://gentlesark.tistory.com/114 [Mac] ๋งฅ์— Homebrew ์„ค์น˜ ๋ฐ brew cask ์„ค์น˜ Ubuntu์— ํŒจํ‚ค์ง€ ๊ด€๋ฆฌ ๋„๊ตฌ apt๊ฐ€ ์žˆ๋‹ค๋ฉด, ๋งฅ์—๋Š” ํŒจํ‚ค์ง€ ๊ด€๋ฆฌ ๋„๊ตฌ Homebrew๊ฐ€ ์žˆ๋‹ค. ๊ทธ๋ฆฌ๊ณ  cask๋Š” ์ด Homebrew์˜ ํ™•์žฅํŒฉ์ด๋ผ๊ณ  ๋ณผ ์ˆ˜ ์žˆ๋Š”๋ฐ, ์ด ๋‘๊ฐ€์ง€ ๋ชจ๋‘ ์„ค์น˜ ๋ฐฉ๋ฒ•์„ ์†Œ๊ฐœํ•œ๋‹ค. Homebrew ์„ค์น˜ ๋ฐฉ๋ฒ• /bi gentlesark.tistory.com ์„ค์น˜ ๋ช…๋ น์–ด brew install mysql@5.7 ์ดํ›„ ์„ธํŒ… mysql ๋ช…๋ น์–ด ์‹คํ–‰์ด ๋˜๋„๋ก ํ™˜๊ฒฝ๋ณ€์ˆ˜์— ๊ฒฝ๋กœ ์„ค์ • echo 'export PATH="/opt/homebrew/opt/mysq.. 2023. 6. 29.
์ดํด๋ฆฝ์Šค(Eclipse) dynamic web project์—์„œ 'Run On Server'์—์„œ 'Choose an existing server' ๋น„ํ™œ์„ฑํ™” ๋ฌธ์ œ ํ•ด๊ฒฐ ๊ฐœ๋ฐœ ํ™˜๊ฒฝ: Tomcat 7.0 Java 1.8 ๊ฐœ๋ฐœ ์ค‘์— ๊ฒช์€ ๋ฌธ์ œ ํ•ด๊ฒฐ์„ ์ตœ๋Œ€ํ•œ ๋ฉ”๋ชจ๋ฅผ ๋‚จ๊ฒจ๋†“๋Š”๋‹ค. ๋ˆ„๊ตฐ๊ฐ€ 1๋ช…์—๊ฒŒ๋ผ๋„ ๋„์›€์ด ๋œ๋‹ค๋ฉด, ๊ทธ๊ฒƒ์œผ๋กœ ์กฑํ•œ๋‹ค. ๋‚ด ๊ฒฝ์šฐ๋Š” Servlet API ๋ฒ„์ „์ด ๋งž์ง€ ์•Š๋Š” ๋ฌธ์ œ์˜€๋‹ค. ์‚ฌ์‹ค ์ž๋ฐ” ๊ธฐ๋ฐ˜์˜ ๋‹ค์ด๋‚˜๋ฏน ์›น ํ”„๋กœ์ ํŠธ ๊ฐœ๋ฐœ ์ดˆ๋ณด๋‹ค ๋ณด๋‹ˆ, ์„œ๋ธ”๋ฆฟ ๋ฒ„์ „์— ๋Œ€ํ•œ ๊ฐœ๋…์ด ๋ถ€์กฑํ–ˆ๋‹ค. ๋‚ด ๊ฒฝ์šฐ์˜ ๋ฌธ์ œ๋Š” Tomcat7.0 ๋ฒ„์ „์€ ์„œ๋ธ”๋ฆฟ 3.0์„ ์ง€์›ํ•˜๋Š”๋ฐ, 3.1์ด์ƒ์˜ ๋ฒ„์ „์œผ๋กœ ์„ค์ •๋˜์–ด ์žˆ์—ˆ๊ธฐ์— ๋ฐœ์ƒํ•œ ๋ฌธ์ œ์˜€๋‹ค. ํ•ด๊ฒฐ๋ฐฉ๋ฒ• ์ดํด๋ฆฝ์Šค ํ”„๋กœ์ ํŠธ๋ฅผ ๋”๋ธ”ํด๋ฆญํ•˜๊ฑฐ๋‚˜ ์šฐํด๋ฆญ์˜ Properties๋กœ ๋“ค์–ด๊ฐ€ ์•„๋ž˜์˜ ๋ฉ”๋‰ด๋กœ ์ง„์ž…ํ•œ ํ›„, ์ฆ‰, project -> Properties -> Project Facets -> Dynamic Web Module ์—์„œ Dynamic Web Module ver.. 2023. 6. 29.
๋งฅ Mac์—์„œ ๋ชจ๋“  ์ฐฝ ์ตœ์†Œํ™”ํ•˜๊ธฐ ๋‹จ์ถ•ํ‚ค ์œˆ๋„์šฐ๋ฅผ ์‚ฌ์šฉํ•  ๋•Œ๋Š” ์•„์ฃผ ์˜ค๋ž˜์ „์ธ 20๋…„ ์ „๋ถ€ํ„ฐ๋„ [์œˆ๋„์šฐ ํ‚ค + M]์œผ๋กœ ๋ชจ๋“  ์ฐฝ ์ตœ์†Œํ™”๋ฅผ ํ•˜์—ฌ ์—ด๋ ค์žˆ๋Š” ๋ชจ๋“  ์œˆ๋„์šฐ๋ฅผ ์ˆจ๊ธฐ๊ณค ํ–ˆ๋‹ค. ๋ฐ”ํƒ•ํ™”๋ฉด์— ์žˆ๋Š” ์•„์ด์ฝ˜์„ ํด๋ฆญํ•˜๊ธฐ ์œ„ํ•ด์„œ๋‚˜ ์•ŒํŠธํƒญ(Alt + Tab)๋ณด๋‹ค ๊ทน๋‹จ์ ์œผ๋กœ ๋ชจ๋“  ์ฐฝ์„ ๋‚ด๋ฆฌ๊ธฐ ์œ„ํ•œ ์ˆ˜๋‹จ์ด์—ˆ๋‹ค. ๋‹น์—ฐํžˆ ์ต์ˆ™ํ•œ ํ–‰์œ„์˜€๊ธฐ์— ๋งฅ์—์„œ๋„ ์ด๋Ÿฌํ•œ ๊ธฐ๋Šฅ์ด ํ•„์š”ํ–ˆ๋‹ค. ์‚ฌ์šฉ์ž๊ฐ€ ํ•„์š”๋กœํ•˜๋Š” ๊ฒƒ์„ ์• ํ”Œ์ด ๋ชจ๋ฅธ ์ฒ™ ํ• ๋ฆฌ๋Š” ์—†์—ˆ๋‹ค. ๊ทธ๋ž˜์„œ ๊ทธ ๋ฐฉ๋ฒ•์„ ์†Œ๊ฐœํ•˜๊ณ ์ž ํ•œ๋‹ค. ๋งฅ(Mac)์—์„œ ๋ชจ๋“  ์ฐฝ ์ตœ์†Œํ™” ํ•˜๋Š” ๋ฐฉ๋ฒ• Command + Option + H, M ๋‹ค์‹œ ๋งํ•ด, Command + Option ๋ˆ„๋ฅธ ์ฑ„๋กœ H ๋ˆ„๋ฅด๊ณ  ๋‹ค์‹œ M ์ •ํ™•ํ•˜๊ฒŒ๋Š”, cmd+option+h๊ฐ€ ์ „๋ฉด์— ์žˆ๋Š” ์•ฑ์„ ์ œ์™ธํ•œ ๋‚˜๋จธ์ง€ ์•ฑ์„ ๋ชจ๋‘ ๊ฐ€๋ฆฌ๊ณ , ์—ฌ๊ธฐ์— cmd+option+m ํ•ด์„œ ์ „๋ฉด์— ์žˆ๋Š” ์•ฑ์„ .. 2022. 9. 8.
Mac Permission denied pulickey ํ•ด๊ฒฐ ๋ฐฉ๋ฒ•(์žฌ๋ถ€ํŒ…) "mac์—์„œ ์žฌ๋ถ€ํŒ…ํ•  ๋•Œ๋งˆ๋‹ค git push๊ฐ€ ์•ˆ๋˜๋Š” ๋ฌธ์ œ ํ•ด๊ฒฐ" mac์œผ๋กœ ๊ฐˆ์•„ํƒ„ ํ›„ ์ž˜ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋˜ github๊ณ„์ •์— push๋ฅผ ํ•˜๋ ค๊ณ  ํ•˜์ž ์•„๋ž˜์™€ ๊ฐ™์€ ๋ฉ”์‹œ์ง€๊ฐ€ ๋‚˜ํƒ€๋‚ฌ๋‹ค. git@github.com: Permission denied (publickey). fatal: Could not read from remote repository. Please make sure you have the correct access rights 1์ฐจ์ ์œผ๋กœ๋Š” ์ด์ „์— ํฌ์ŠคํŒ…ํ•œ ์ ์ด ์žˆ๋Š”, ์•„๋ž˜์˜ ๊ธ€๋กœ ํ•ด๊ฒฐ์ด ๋๋‹ค. https://gentlesark.tistory.com/86 Git Push๋ฅผ ๊ท€์ฐฎ๊ฒŒ ๋งŒ๋“œ๋Š” ์—๋Ÿฌ ํ•ด๊ฒฐ: Enter passphrase for key '~/.ssh/id_rsa' ๋ฌธ์ œ์™€ Could not .. 2022. 9. 7.
mac์—์„œ ssh-key ์ƒ์„ฑํ•˜๊ธฐ(ssh-keygen) 1. ํ„ฐ๋ฏธ๋„์„ ์‹คํ–‰ํ•œ๋‹ค. (์œ„์™€ ๊ฐ™์€ ์•„์ด์ฝ˜) 2. ์•„๋ž˜์˜ ๋ช…๋ น์–ด๋ฅผ ์‹คํ–‰ํ•œ๋‹ค. (์ด๋ฉ”์ผ ์ฃผ์†Œ๋Š” ๋ณธ์ธ์— ๋งž๊ฒŒ ๋ณ€๊ฒฝ) ssh-keygen -C "abcd@naver.com" 3. ์•„๋ž˜์˜ ๋ฉ”์‹œ์ง€๊ฐ€ ๋‚˜์˜ค๋ฉด Enter๋ฅผ ์ž…๋ ฅํ•œ๋‹ค. (๊ธฐ๋ณธ ๊ฒฝ๋กœ์— ์ €์žฅ, username์€ ์‚ฌ์šฉ์ž ์ด๋ฆ„์— ๋งž๊ฒŒ ๋‚˜์˜ด) Generating public/private rsa key pair. Enter file in which to save the key (/Users/username/.ssh/id_rsa): 4. ์›ํ•˜๋Š” ๊ณณ์—์„œ public key์ธ ~/.ssh/id_rsa.pub ์„ ์‚ฌ์šฉํ•˜๋ฉด ๋œ๋‹ค. ๋. 2022. 9. 7.
๋ฐ”ํƒ•ํ™”๋ฉด ์ƒ‰์ƒ์—(background-color)์— linear-gradient๊ฐ€ ์ ์šฉ๋˜์ง€ ์•Š์•„์š”(CSS ๋ฌธ์ œ) ํ•ด๋‹น ๋ฌธ์ œ๋Š” body์— ์ ์šฉ๋˜๋Š” css์˜ ๋ฌธ์ œ์˜€์Œ. background-color์— ์ ์šฉ๋˜์ง€ ์•Š๋Š” ๊ฒƒ์„ background๋กœ ๋ฐ”๊ฟ”์ฃผ๋ฉด ํ•ด๊ฒฐ ๋จ. Before: background-color: linear-gradient(180deg, #f08, #d0e); After: background: linear-gradient(180deg, #f08, #d0e); ์ฐธ๊ณ  https://developer.mozilla.org/en-US/docs/Web/CSS/gradient/linear-gradient Because s belong to the data type, they can only be used where s can be used. For this reason, linear-gradient() won't wo.. 2022. 8. 3.
Ubuntu 16.04 ๋ฉ”๋‰ด๋ฐ” ํ„ฐ๋ฏธ๋„ ์‚ฌ๋ผ์ง ๋ฌธ์ œ ํ•ด๊ฒฐ ๋“ฑ "Ubuntu์—์„œ Python ํ•จ๋ถ€๋กœ ์ง€์šฐ์ง€ ๋งˆ์„ธ์š”..." Ubuntu16.04๋Š” python3.5๊นŒ์ง€๋งŒ ์ง€์›์ด ๋˜๋Š” ๋ฐ”๋žŒ์— ์ž˜ ์•ˆ๋Œ์•„๊ฐ€๋Š” ํ”„๋กœ๊ทธ๋žจ๋“ค์ด ์ข…์ข… ์žˆ์–ด์„œ ํŒŒ์ด์ฌ ๋ฒ„์ „์„ ์˜ฌ๋ฆฌ๋ ค๊ณ  ์•„๋ž˜์™€ ๊ฐ™์€ ๋ช…๋ น์–ด๋ฅผ ์ณค๋‹ค๊ฐ€ ๊ณ ์ƒ์ด๋ž€ ๊ณ ์ƒ์€ ๋‹คํ–ˆ๋„ค์š” ใ… ใ…  sudo apt-get remove python python3 ์ด๋Ÿฐ ๋ช…๋ น์–ด ์ ˆ๋Œ€ ์ ˆ๋Œ€ ์ž…๋ ฅํ•˜์ง€ ๋งˆ์‹œ๊ธฐ ๋ฐ”๋ž๋‹ˆ๋‹ค!! Python๋„ ๋ฏธ์น ๋“ฏํ•œ ์—๋Ÿฌ ํ•ด๊ฒฐ๋กœ ์—„์ฒญ ๊ณ ์ƒํ–ˆ๋Š”๋ฐ, ์ด ๋ถ€๋ถ„์€ ๊ธฐํšŒ๋˜๋ฉด ๋”ฐ๋กœ ๊ธ€ ๋‚จ๊ธฐ๊ฒ ์Šต๋‹ˆ๋‹ค... dependency๊ฑธ๋ฆฐ ๊ฒƒ๋“ค์ด ์šฐ๋ฅด๋ฅด ๋‚ ์•„๊ฐ€๋Š” ๋ฐ”๋žŒ์— ์ง€๊ธˆ๋„ ์ •์ƒ์€ ์•„๋‹Œ OS๋ฅผ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค ๐Ÿคฃ๐Ÿคฃ๐Ÿคฃ (๋ฉ”๋‰ด๋ฐ”์ธ ๊ทธ๋†ˆ, ํ„ฐ๋ฏธ๋„๊ณผ ๊ฐ™์€ ๊ธฐ๋ณธ of ๊ธฐ๋ณธ๋ถ€ํ„ฐ mysql๊ฐ™์€ ์•„์ฃผ ์ค‘์š”ํ•œ ๋†ˆ๋“ค๊นŒ์ง€ ์‹ธ๊ทธ๋ฆฌ ๋‚ ์•„๊ฐ€๋ฒ„๋ฆฐ...) ์ด์— ๊ด€๋ จ FIX ๊ธฐ๋ก์„ ๋‚จ๊ฒจ๋ด…๋‹ˆ.. 2022. 6. 22.