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


๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ

(223)
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 ์‚ฌ์šฉ์ž ๊ถŒํ•œ์„ ๊ฐ€์ง€๊ณ  ์žˆ์ง€ ์•Š์€..
๋„ฅ์‚ฌํฌ๋กœ ๊ทธ๋ฆฌ๋“œ mask https://www.playnexacro.com/#show:techtip:480 play nexacro:ํ”Œ๋ ˆ์ด ๋„ฅ์‚ฌํฌ๋กœ Play Nexacro is a community site for nexacro platform. ๋„ฅ์‚ฌํฌ๋กœ ํ”Œ๋žซํผ ์‚ฌ์šฉ์ž ์ปค๋ฎค๋‹ˆํ‹ฐ www.playnexacro.com transaction ์‚ฌ์šฉ๋ฐฉ๋ฒ• Form.transaction( strSvcID, strURL, strInDatasets, strOutDatasets, strArgument, strCallbackFunc [,bAsync [,nDataType [,bCompress]]] ) Application.transaction( strSvcID, strURL, strInDatasets, strOutDatasets, strArgu..
๋„ฅ์‚ฌํฌ๋กœ Dataset ๋ฐ์ดํ„ฐ์…‹ ๋™์  ์ƒ์„ฑ - ์•„๋ž˜ ์†Œ์Šค๋Š” Dataset์„ ์ƒ์„ฑํ•˜๋Š” ๋‘๊ฐ€์ง€ ์˜ˆ์ œ๋ฅผ ๋ณด์—ฌ์ค€๋‹ค - ์ฒซ๋ฒˆ์งธ๋Š” ๋นˆ Dataset์„ ์ƒ์„ฑํ•˜๊ณ  ๋‘๋ฒˆ์งธ๋Š” ๋ฐ์ดํ„ฐ์…‹์˜ id์™€ ์ปฌ๋Ÿผ, ๋ฐ์ดํ„ฐ๋ฅผ ์ถ”๊ฐ€ํ•˜๋Š” ์˜ˆ์ œ //Dataset Object ์ƒ์„ฑ ์˜ˆ์ œ 1 this.dataset_test1 = new Dataset(); trace("\n" + this.dataset_test1.saveXML()); //Dataset Object ์ƒ์„ฑ ์˜ˆ์ œ 2 (id ํฌํ•จ) this.dataset_test2 = new Dataset("dataset_test2"); //์ปฌ๋Ÿผ ์ถ”๊ฐ€ this.dataset_test2.addColumn("col1"); this.dataset_test2.addColumn("col2"); //๋ฐ์ดํ„ฐ ์ถ”๊ฐ€ var currentRow..
์œˆ๋„์šฐ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
[Pandas] Dataframe ์ธ๋ฑ์Šค to list ๋ณ€ํ™˜ to_list() ์‚ฌ์šฉ >>> idx = pd.Index([1, 2, 3]) >>> idx Index([1, 2, 3], dtype='int64') >>> idx.to_list() [1, 2, 3] https://pandas.pydata.org/docs/reference/api/pandas.Index.tolist.html pandas.Index.tolist — pandas 2.1.1 documentation Return the array as an a.ndim-levels deep nested list of Python scalars. pandas.pydata.org
[Pandas] Dataframe ์ „์ฒด ์ถœ๋ ฅํ•˜๊ธฐ import numpy as np from sklearn.datasets import load_iris import pandas as pd # Loading irirs dataset data = load_iris() df = pd.DataFrame(data.data, columns = data.feature_names) display(df) import numpy as np from sklearn.datasets import load_iris import pandas as pd data = load_iris() df = pd.DataFrame(data.data, columns = data.feature_names) # The scope of these changes made to # pandas sett..
๋งˆํ”์— ์ฝ๋Š” ์‡ผํŽœํ•˜์šฐ์–ด '๋ฐ–์ด ์•„๋‹Œ ์•ˆ์—์„œ ํ–‰๋ณต์„ ์ฐพ์•„๋ผ.' ์šฐ๋ฆฌ๊ฐ€ ๋ถˆํ–‰ํ•œ ์ด์œ ๋Š” ๋Œ€๋ถ€๋ถ„ ํƒ€์ธ์—๊ฒŒ ์˜์ง€ํ•˜๊ธฐ ๋•Œ๋ฌธ์ด๋‹ค. ์ฒซ ๋ฒˆ์งธ ๋‹จ๊ณ„ - ๋ฌด๊ธฐ๋ฌผ ๋‘ ๋ฒˆ์งธ ๋‹จ๊ณ„ - ์‹๋ฌผ ์„ธ ๋ฒˆ์งธ ๋‹จ๊ณ„ - ๋™๋ฌผ ๋„ค ๋ฒˆ์งธ ๋‹จ๊ณ„ - ์ธ๊ฐ„ ๋†’์€ ๋‹จ๊ณ„์ผ์ˆ˜๋ก ์ฐจ์ด์ . ์ฆ‰ ๊ฐœ๋ณ„์ ์ธ ํŠน์„ฑ์ด ๋” ๋„๋“œ๋ผ์ง„๋‹ค. ์˜ค์ง ์ธ๊ฐ„๋งŒ์ด '์ž์‹ ์˜ ์ƒ‰'์„ ์ฐพ์•„ ๊ฐœ์„ฑ์žˆ๊ฒŒ ์‚ด ์ˆ˜ ์žˆ๋‹ค. ์ด ์‚ฌ์‹ค์— ๋Œ€ํ•ด ๋”ฑํžˆ ์ƒ๊ฐํ•˜์ง€ ์•Š๊ฑฐ๋‚˜ ๊ด€์‹ฌ์ด ์—†์œผ๋ฉด, ๊ณตํ—ˆํ•˜๋‹ค. ์‚ถ์˜ ์–ด๋Š ์˜์—ญ์—์„œ๋“  ๊ฒฐํ•์ด ๋Š๊ปด์ง„๋‹ค. ๊ทธ๋ž˜์„œ ๋‚˜์™€ ๊ฐ™์€ ์ข…์ธ ํƒ€์ธ์—๊ฒŒ ํฌ๋ง์„ ๊ฑด๋‹ค. ๋‚˜๋Š” ๋‚ด ๊ฐœ์„ฑ์œผ๋กœ ์กด์žฌ ํ•ด์•ผ ํ•˜๋Š”๋ฐ ๋‚ด ๋ณธ์งˆ์„ ๋ชจ๋ฅด๊ธฐ ๋•Œ๋ฌธ์— ํƒ€์ธ์˜ ๋ˆˆ์— ์˜์ง€ํ•œ๋‹ค. ๋‚จ์ด ์‹œํ‚ค๋Š” ๊ฑฐ ๋ง๊ณ , ์ž์‹ ์ด ์›ํ•˜๋Š” ๊ฒƒ์„ ํ•  ๋•Œ ์ธ๊ฐ„์€ ๋น„๋กœ์†Œ ํ–‰๋ณตํ•ด์ง„๋‹ค๋Š” ๊ฒƒ ํ˜ธ๊ฐ๊ฐ€๋Š” ์‚ฌ๋žŒ์ด ๋˜๊ธฐ๋ฅผ ํฌ๊ธฐํ•ด๋ผ. ์–ด๋–ป๊ฒŒ ํ•ด์•ผ ๋‚ด ์ฃผ๋ณ€์ธ๋“ค์— ๋งˆ์Œ์— ๋“ค๊นŒ ๊ณ ๋ฏผ ํ•˜์ง€๋ง๋ผ...
๋ถˆ๋ฒ• ์†Œํ”„ํŠธ์›จ์–ด ์‚ฌ์šฉ ์‹œ, ์ž…์„ ์ˆ˜ ์žˆ๋Š” ์†ํ•ด ์šฐ๋ฆฌ๊ฐ€ ํ”ํžˆ ์•Œ๊ณ  ์žˆ๋Š” ์ƒ์šฉ ์†Œํ”„ํŠธ์›จ์–ด๋ž€ ์ „๋ฌธ๊ธฐ๊ด€์— ์˜ํ•ด ์ƒ์—…์  ๋ชฉ์ ์œผ๋กœ ๊ฐœ๋ฐœ๋˜์–ด ์ •๋‹นํ•œ ๋น„์šฉ์„ ์ง€๋ถˆํ•˜๊ณ  ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๊ฒŒ ํŒ๋งคํ•˜๋Š” ์†Œํ”„ํŠธ์›จ์–ด์ธ๋ฐ์š”. ๊ฐ๊ฐ์˜ ์ƒ์šฉ ์†Œํ”„ํŠธ์›จ์–ด์—๋Š” ๋ผ์ด์„ ์Šค๊ฐ€ ์กด์žฌํ•˜๊ณ  ๋…์  ๋ฐฐํƒ€๊ถŒ์„ ๊ฐ€์ง„ ๊ถŒ๋ฆฌ์ž๊ฐ€ ์ผ์ •ํ•œ ๋Œ€๊ฐ€์˜ ์ง€๊ธ‰์„ ์กฐ๊ฑด์œผ๋กœ ์‚ฌ์šฉ์ž์—๊ฒŒ ๊ถŒ๋ฆฌ๋ฅผ ๋ถ€์—ฌํ•ด ์ฃผ๋Š” ๊ฒƒ์ด๋ž๋‹ˆ๋‹ค. ์ด๋Ÿฌํ•œ ๋ผ์ด์„ ์Šค๋ฅผ ์ทจ๋“ ์—†์ด ๋ฌด๋‹จ์œผ๋กœ ์‚ฌ์šฉํ•  ๊ฒฝ์šฐ๋‚˜ ์ •ํ•ด์ง„ ์†Œํ”„ํŠธ์›จ์–ด ๋ผ์ด์„ ์Šค์˜ ์‚ฌ์šฉ๋ฒ”์œ„๋ฅผ ๋ฒ—์–ด๋‚˜ ์‚ฌ์šฉํ•  ๊ฒฝ์šฐ์—๋„ ์ €์ž‘๊ถŒ ์นจํ•ด์— ํ•ด๋‹น์ด ๋˜๊ณ , ๋˜ํ•œ ์—ฌ๋Ÿฌ ๊ฐœ์˜ ์ •ํ’ˆ์„ ๊ฐ€์ง€๊ณ  ์žˆ์–ด๋„ ์ ์€ ์ˆ˜๋Ÿ‰์„ ๋ถˆ๋ฒ• ์†Œํ”„ํŠธ์›จ์–ด๋กœ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋‹ค๋ฉด ์ €์ž‘๊ถŒ ์นจํ•ด์˜ ์œ ํ˜•์— ํ•ด๋‹น๋˜๋‹ˆ ์‚ฌ์šฉ๋˜๋Š” PC์˜ ์†Œํ”„ํŠธ์›จ์–ด๋Š” ๋ชจ๋‘ ์ •ํ’ˆ์„ ์‚ฌ์šฉํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ์ธํ„ฐ๋„ท์— ๋ฌด๋ฃŒ๋กœ ์ œ๊ณตํ•˜๋Š” ๋ถˆ๋ฒ• ์†Œํ”„ํŠธ์›จ์–ด๋ฅผ ํšŒ์‚ฌ ์ปดํ“จํ„ฐ์— ๋‹ค์šด๋กœ๋“œ ํ•œ ๊ฒฝ์šฐ, ์ €์ž‘๊ถŒ๋ฒ• ์ œ136์กฐ ์ œ..