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

studies112

Linux ๋ฆฌ๋ˆ…์Šค์—์„œ Java ํด๋ž˜์Šค ํŒŒ์ผ ์ปดํŒŒ์ผํ•˜๊ธฐ javac ํด๋ž˜์Šค๋ช….java java ํด๋ž˜์Šค๋ช… 2020. 5. 30.
[MariaDB/JSP] ClassNotFoundException ์—๋Ÿฌ ํ•ด๊ฒฐ๋ฐฉ๋ฒ• Eclipse์—์„œ Dynamic Web Project๋กœ JSP์ฝ”๋“œ๋ฅผ ์งœ๋‹ค๊ฐ€ ๋ถ„๋ช… ๊ตฌ๊ธ€๋ง๋Œ€๋กœ mariadb-java-client.jar ํŒŒ์ผ์„ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ์— ์ถ”๊ฐ€ํ•˜์˜€์Œ์—๋„ ๋ถˆ๊ตฌํ•˜๊ณ  ClassNotFoundException๊ฐ€ ๊ณ„์† ๋–ด๋‹ค. ์›์ธ๋ถˆ๋ช… ์ƒํƒœ.. ํ•ด๊ฒฐ๋ฐฉ๋ฒ•: ํ”„๋กœ์ ํŠธ ์šฐํด๋ฆญ>Properties>Deployment Assembly>Add>Java Build Path Entries ์„ ํƒ>mariadb-java-client.jar ์„ ํƒ>์ถ”๊ฐ€์™„๋ฃŒ>์ดํด๋ฆฝ์Šค ์žฌ๋ถ€ํŒ…(๊ถŒ์žฅ) mariadb ์ „์šฉ JDBC๊ฐ€ ๊ฒฐ๊ตญ WEB-INF/libํด๋”์—๋„ ์œ„์น˜ํ•˜๋Š”๊ฒŒ ์ค‘์š”ํ•œ ๋“ฏ ํ•˜๋‹ค. 2020. 5. 27.
[MariaDB] INSERT๋ฌธ ํ•œ๊ธ€ ์˜ค๋ฅ˜(Incorrect string value) ํ•ด๊ฒฐ my.ini ํŒŒ์ผ์— ์•„๋ž˜ ์†์„ฑ์„ ์ง€์ • [mysqld] init_connect="SET collation_connection = utf8_general_ci" init_connect="SET NAMES utf8" collation-server = utf8_general_ci character-set-server = utf8 [client] default-character-set = utf8 [mysql] default-character-set=utf8โ€‹ Mysql> SHOW VARIABLES LIKE "c%" ๋ช…๋ น ์ž…๋ ฅ ํ›„ Value๊ฐ’์— 'latin1'์ด ์žˆ์œผ๋ฉด ์•ˆ๋จ. ๋ชจ๋‘ 'utf8'๋กœ ๋ฐ”๊พผ๋‹ค. ์ฟผ๋ฆฌ์ฐฝ์—์„œ ์†์„ฑ ์„ค์ •์„ ํ•  ์ˆ˜ ์žˆ๋‹ค. (my.ini ์ˆ˜์ •๋งŒ์œผ๋กœ ๋ณ€๊ฒฝ ์•ˆ ๋  ๊ฒฝ์šฐ) Mysql> SET [Var.. 2020. 5. 26.
[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.
Github ๋ˆ„๊ตฌ๋‚˜ ์‚ฌ์šฉ ๊ฐ€๋Šฅํ•œ ๋ฌด๋ฃŒ ํ˜ธ์ŠคํŒ… ์ด์šฉ https://์‚ฌ์šฉ์ž์•„์ด๋””.github.io/๋ฆฌํฌ์ง€ํ† ๋ฆฌ๋ช…/ 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.
728x90
๋ฐ˜์‘ํ˜•