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

๊ฐ•ํ™”๋„๋ผ์ดํ”„/๋ธ”๋กœ๊ทธ & ์›น ์‚ฌ์ดํŠธ

[Python Error ์ •๋ฆฌ] pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")

ํŒŒ์ด์ฌ ๋…ํ•™ ์ถ”์ฒœ ๋„์„œ

ํ˜ผ์ž ๊ณต๋ถ€ํ•˜๋Š” ํŒŒ์ด์ฌ:1:1 ๊ณผ์™ธํ•˜๋“ฏ ๋ฐฐ์šฐ๋Š” ํ”„๋กœ๊ทธ๋ž˜๋ฐ ์ž์Šต์„œ, ํ•œ๋น›๋ฏธ๋””์–ด Do it! ์ ํ”„ ํˆฌ ํŒŒ์ด์ฌ:์ด๋ฏธ 200๋งŒ๋ช…์ด ์ด ์ฑ…์œผ๋กœ ํ”„๋กœ๊ทธ๋ž˜๋ฐ์„ ์‹œ์ž‘ํ–ˆ๋‹ค!, ์ด์ง€์Šคํผ๋ธ”๋ฆฌ์‹ฑ ๋งŒ๋“ค๋ฉด์„œ ๋ฐฐ์šฐ๋Š” ํŒŒ์ด์ฌ๊ณผ 40๊ฐœ์˜ ์ž‘ํ’ˆ๋“ค:์ž๋™ํ™” ํฌ๋กค๋ง ์ด๋ฏธ์ง€์ฒ˜๋ฆฌ ๋ฐ์ดํ„ฐ๋ถ„์„ ์›นํŽ˜์ด์ง€ GUI ํ”„๋กœ๊ทธ๋žจ ๊ฒŒ์ž„, ์•ค์จ๋ถ

Python Error ์ •๋ฆฌ

 

pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")

 

mysql์— ์ ‘์† ํ•  ๋•Œ ์‚ฌ์šฉํ•˜๋Š” ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ์ ์–ด์ฃผ๋ฉด ๋œ๋‹ค. 

connect = pymysql.connect(
    host = 'localhost',
    user = 'root',
    password = '์—ฌ๊ธฐ์— sql์— ์ ‘์†ํ• ๋•Œ์˜ ๋น„๋ฒˆ์„ ์ ์–ด์ค€๋‹ค.',
    db = 'test',
    charset = 'utf8'
)

 

๋ฐ˜์‘ํ˜•