songining
4. ๋ฆฌ์•กํŠธ - mysql - node.js ์—ฐ๋™
WEB/REACT 2021. 1. 29. 22:48

๋‚˜๋Š” ๋‚ด๋ถ€ mysql์„ ์ด์šฉํ•˜์˜€๋‹ค. * ํ„ฐ๋ฏธ๋„์—์„œ mysql ์‹คํ–‰ ๋ฐฉ๋ฒ• 1. mysql.server start 2. mysql -uroot -p 3. ๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ management ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์™€ customerํ…Œ์ด๋ธ”์„ ์ƒ์„ฑ ํ›„ ์‚ฌ์šฉ์ž๋“ค์„ ์ž„์˜๋กœ ์‚ฝ์ž…ํ•ด์ฃผ์—ˆ๋‹ค. ์šฐ์„  npm install mysql์„ ํ„ฐ๋ฏธ๋„์— ์ž…๋ ฅํ•˜์—ฌ ํ˜„์žฌ ํ”„๋กœ์ ํŠธ ํด๋”์— mysql ํŒจํ‚ค์ง€๋ฅผ ์„ค์น˜ํ•œ๋‹ค. ๊ทธ๋ฆฌ๊ณ  ์„œ๋ฒ„์— database.json ํŒŒ์ผ์„ ๋งŒ๋“ค์–ด { "host":"0.0.0.0", "user":"user", "password":"user ๋น„๋ฐ€๋ฒˆํ˜ธ", "port":"3306", "database":"management" } ์œ„์™€ ๊ฐ™์ด ์ž‘์„ฑํ•ด์ค€๋‹ค. ๊ทธ๋ฆฌ๊ณ  server.js ์—์„œ database.jsonํŒŒ์ผ์„ ์ฝ์–ด์™€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์™€ ์—ฐ..