๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
728x90
๋ฐ˜์‘ํ˜•

studies/Back-end66

[MariaDB] ์‚ฌ์šฉ์ž ๊ณ„์ • ์กฐํšŒ ์•ˆ๋  ๋•Œ, root ์ ‘์† ์˜ค๋ฅ˜ ํ•ด๊ฒฐ, ์‚ฌ์šฉ์ž ๊ณ„์ • ์ „ํ™˜ํ•˜๊ธฐ Mariadb root user access denied ์–ด์ฉŒ๊ณ ์ €์ฉŒ๊ณ  ์˜ค๋ฅ˜๊ฐ€ ๋œฐ๋•Œ,  ์•„๋งˆ ์ฝ˜์†” ์ฐฝ ์ž…๋ ฅ ์ค„์— MariaDB [(none)]> ๋ผ๊ณ  ๋˜์–ด์žˆ์„ ๊ฒƒ์ด๋‹ค.show db ๊ฐ™์€ ์ฟผ๋ฆฌ๋Š” ๋จน๋Š”๋ฐ select ๋“ฑ ๋‹ค๋ฅธ๊ฑด ์•ˆ ๋œ๋‹ค. ์•„๋ž˜๋ฅผ ๋”ฐ๋ผํ•˜๋ฉด ์‚ฌ์šฉ์ž ๊ณ„์ • ์กฐํšŒ๋ฅผ ํ•  ์ˆ˜ ์žˆ๋‹ค. MariaDB [(none)]> use mysql; Database changed MariaDB [mysql]> select host,user from user;  ์‚ฌ์šฉ์ž ๊ณ„์ • ์ „ํ™˜ํ•˜๊ธฐ MariaDB Client ์ฝ˜์†” ํ”„๋กœ๊ทธ๋žจ์—์„œ ์ฒ˜์Œ์—๋Š” ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ์ž…๋ ฅํ•˜๋ผ๊ณ  ๋‚˜์˜จ๋‹ค. ์•„๋งˆ root:localhost ๊ธฐ๋ณธ ๊ณ„์ •์— ์ ‘์†ํ•˜๋Š” ๊ฒƒ ๊ฐ™๋‹ค. MariaDB [none]> quit ์ž…๋ ฅํ•˜๋ฉด Sql ํด๋ผ์ด์–ธํŠธ ์ฐฝ์—์„œ ๋‚˜๊ฐ€์ง€๊ณ  MariaDB์„ค.. 2020. 5. 19.
[MariaDB] Sql ๋ฌธ๋ฒ• ์ •๋ฆฌ SQL Query ๋ชฉ๋กhttps://mariadb.com/kb/ko/basic-sql-statements/ ๊ธฐ๋ณธ SQL ๋ฌธ์žฅ์ด ํŽ˜์ด์ง€ ๋ชฉ๋ก์—๋Š” ๊ฐ€์žฅ ์ค‘์š”ํ•œ SQL ๋ฌธ์žฅ๋“ค๊ณผ ๊ทธ ๋ฌธ์žฅ์— ๊ด€๋ จ๋œ ๋ฌธ์„œ์— ๋Œ€ํ•œ ๋งํฌ๋ฅผ ํฌํ•จํ•˜๊ณ  ์žˆ๋‹ค. ๋งŒ์•ฝ ์—ฌ๋Ÿฌ๋ถ„์—๊ฒŒ MariaDB ์„œ๋ฒ„๋ฅผ ์–ด๋–ป๊ฒŒ ์‚ฌ์šฉํ•˜๋Š”์ง€ ๊ฐ„๋‹จํ•œ ๋ช…๋ น์–ด๋“ค์„ ์–ด๋–ป๊ฒŒ ์‹คํ–‰ํ•ด์•ผํ•˜๋Š”๏ฟฝ๏ฟฝmariadb.com ์ด๋ก  ์ •๋ณดhttps://m.blog.naver.com/PostView.nhn?blogId=hmkuak&logNo=220583392375&proxyReferer=https:%2F%2Fwww.google.com%2F MariaDB ๊ด€๋ จ ์ž๋ฃŒ๋ชจ์Œ (โ€ปSQL) (์ด๋ก /๋ฌธ๋ฒ•/์‚ฌ์šฉ)โ–ผ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ด๋ก  (1) ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ฐœ์š” ๋ฐ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์‹œ์Šคํ…œ http://seungp916... 2020. 5. 19.
[JSP] ์ดํด๋ฆฝ์Šค์—์„œ Mapping - WebContent์˜ 'web.xml' ์ƒ์„ฑํ•˜๊ธฐ (eclipse IDE 2019-12 ver.) Dynamic Web Project ํ”„๋กœ์ ํŠธ ํด๋” ์ƒ์„ฑ์‹œ Next๋ฅผ ๋ˆ„๋ฅด๋‹ค ๋งˆ์ง€๋ง‰ ๋ชจ๋“ˆ ์„ค์ • ํŽ˜์ด์ง€์—์„œ ๋งจ ์•„๋ž˜ ์ฒดํฌ๋ฐ•์Šค๋ฅผ ํ†ตํ•ด web.xml ํŒŒ์ผ์„ ์ƒ์„ฑ์‹œํ‚ฌ ์ˆ˜ ์žˆ๋‹ค.  ๊ทธ๋Ÿฌ๋‚˜ ๊นŒ๋จน๊ณ  ์ด ๋ฐ•์Šค๋ฅผ ์ฒดํฌํ•˜์ง€ ์•Š๊ณ  ํ”„๋กœ์ ํŠธ๋ฅผ ๋งŒ๋“  ๊ฒฝ์šฐ web.xml ํŒŒ์ผ์„ ์ง์ ‘ ์ƒ์„ฑํ•ด ์ž‘์„ฑํ•˜๊ฑฐ๋‚˜ ํ”„๋กœ์ ํŠธ๋ฅผ ๋‹ค์‹œ ๋งŒ๋“ค ํ•„์š” ์—†์ด ์ž๋™ ์ƒ์„ฑํ•˜๋Š” ๋ฐฉ๋ฒ•์ด ์žˆ๋‹ค. ํ”„๋กœ์ ํŠธ ์šฐํด๋ฆญ  6๋ฒˆ์งธ ๋ธ”๋ก์˜ Java EE Tools → Generate Deployment Descripter Stup ํด๋ฆญ ์ƒ์„ฑ ์œ„์น˜ ํ”„๋กœ์ ํŠธ\WebContent\WEB-INF\web.xml 2020. 4. 28.
[Python] ํŒŒ์ด์ฌ Turtle ๋กœ GUI์— ๋„ํ˜• ๊ทธ๋ฆฌ๊ธฐ 1. ์ฐฝ ๋งŒ๋“ค๊ธฐ (Python Turtle Graphics)import turtle as tt.shape("turtle") 2. ์ •์‚ผ๊ฐํ˜• ๊ทธ๋ฆฌ๊ธฐt.forward(100)t.left(120) #๊ฐ๋„ ์ด๋™t.forward(100)t.left(120)t.forward(100) 3. ์ •์œก๊ฐํ˜• ๊ทธ๋ฆฌ๊ธฐt.forward(200)for i in range(5): t.right(60) t.forward(200) 4. ์ •์˜ค๊ฐํ˜• ๊ทธ๋ฆฌ๊ธฐt.forward(150)for i in range(4): t.right(72) t.forward(150) 5. ๋ณ„ ๊ทธ๋ฆฌ๊ธฐt.forward(100)for i in range(4) t.right(144) t.forward(100) 6. ์› ๊ทธ๋ฆฌ๊ธฐt.forward(.. 2020. 4. 24.
[MariaDB] JDBC ์—ฐ๋™ํ•˜๊ธฐ in Eclipse (java์™€ ์—ฐ๋™) Java ์ฝ”๋“œ ๋‚ด์—์„œ ๋งˆ๋ฆฌ์•„db๋ฅผ ์‚ฌ์šฉํ•˜๊ธฐ ์œ„ํ•ด JDBC๋ฅผ ์—ฐ๊ฒฐํ•ด๋ณด๊ฒ ๋‹ค. https://downloads.mariadb.org/connector-java/2.6.0/ MariaDB Connector/J 2.6.0 Stable - MariaDB downloads.mariadb.org ๋‹ค์šด๋ฐ›์€ jarํŒŒ์ผ์„ ์‚ฌ์šฉํ•  ํ”„๋กœ์ ํŠธ๊ฐ€ ์žˆ๋Š” ์›Œํฌ์ŠคํŽ˜์ด์Šค ํด๋”์— ๋„ฃ์–ด์ฃผ์—ˆ๋‹ค. ์ด์ œ ์ดํด๋ฆฝ์Šค๋กœ ์™€์„œ ๋งˆ๋ฆฌ์•„db๋ฅผ ์‚ฌ์šฉํ•  ํ”„๋กœ์ ํŠธ ์šฐํด๋ฆญ>Properties>Java Build Path ์•„๊นŒ ์˜ฎ๊ฒผ๋˜ jarํŒŒ์ผ ์„ ํƒ ClassNotFoundException ์˜ค๋ฅ˜ ํ•ด๊ฒฐํ•˜๊ธฐ: https://we-always-fight-with-code.tistory.com/61 [MariaDB/JSP] ClassNotFoundException ์—๋Ÿฌ ํ•ด.. 2020. 4. 23.
Eclipse / Github branch Push ์˜ค๋ฅ˜ rejected - non-fast-forward ํ•ด๊ฒฐํ•˜๊ธฐ ์™ ๋งŒํ•ด์„œ ์ด๊ฑฐ ๋‘๋ฐฉ์ด๋ฉด ๋ฐ”๋กœ ๋œ๋‹ค. ๋งˆ์น˜ ์•Œ๋ณด์น ๊ฐ™๋‹ค. Push rejected - non-fast-forward ์—๋Ÿฌ ํŒ์—…์€ ์ œ๋Œ€๋กœ ๋œ ์ด์œ ๋„ ์„ค๋ช…ํ•ด์ฃผ์ง€ ์•Š์•„ ๋งŽ์ด ํ•ด๋งค๊ฒŒ ๋œ๋‹ค. ์ฒซ๋ฒˆ์งธ ํ•ด๊ฒฐ๋ฐฉ๋ฒ•์€ Pull์ด๋‹ค. ์ด๋”ฐ๊ธˆ ์•ˆ๋“œ๋กœ์ด๋“œ ์ŠคํŠœ๋””์˜ค์—์„œ ์ž‘์—…์„ ํ•˜๋˜ ์ค‘ ๊นƒํ—ˆ๋ธŒ์—์„œ .gitignoreํŒŒ์ผ์ด๋‚˜ README.mdํŒŒ์ผ์„ ์ƒ์„ฑํ•  ์ˆ˜ ์žˆ๋‹ค. ์ด๋•Œ ๋ฆฌํฌ์ง€ํ† ๋ฆฌ์™€ ์—ฐ๊ฒฐ๋œ ์•ˆ๋“œ๋กœ์ด๋“œ ์ŠคํŠœ๋””์˜ค์˜ ํ”„๋กœ์ ํŠธ์— ์ด ํŒŒ์ผ๋“ค์ด ์—†์œผ๋ฉด Push๊ฐ€ ๋˜์ง€ ์•Š๋Š”๋‹ค. ์ด๋•Œ ์•ˆ๋“œ๋กœ์ด๋“œ ์ŠคํŠœ๋””์˜ค ๋‚ด์—์„œ ๋˜‘๊ฐ™์ด ํ•ด๋‹น ํŒŒ์ผ์„ (๊ฐ™์€์ด๋ฆ„์œผ๋กœ)์ƒ์„ฑํ•ด์ฃผ๋ฉด ํ•ด๊ฒฐ์ด ๋˜๊ธด ํ•˜๋‚˜, ๋„ˆ๋ฌด ๋ฒˆ๊ฑฐ๋กญ๋‹ค. Pull์„ ํ•˜๋ฉด ์ด ํŒŒ์ผ์ด ๊นƒํ—ˆ๋ธŒ์—์„œ ํ”„๋กœ์ ํŠธ๋กœ ๋“ค์–ด์˜จ๋‹ค. ๊ทธ๋ž˜๋„ ์•ˆ๋œ๋‹ค๋ฉด, ๋‘๋ฒˆ์งธ ๋ฐฉ๋ฒ•์€ Branch rebase๋‹ค! Git ๋ฉ”๋‰ด์—์„œ Branches๋ฅผ ๋“ค์–ด๊ฐ€๋ฉด.. 2020. 4. 19.
728x90
๋ฐ˜์‘ํ˜•