Goorm IDE MySQL / phpmyadmin ์…‹์—…

1. ์ปจํ…Œ์ด๋„ˆ ์ƒ์„ฑ์‹œ Blank / MySQL / mysql-cli ์„ ํƒ

2. ์™„๋ฃŒ ํ›„ workspace directory์—์„œ https://help.goorm.io/ko/goormide/17.faq/language-and-environment/install-phpmyadmin ๋‚˜์™€์žˆ๋Š” ๋ช…๋ น์–ด ์ž…๋ ฅ

// PHP ๋ฒ„์ „ 7.2 ๊ธฐ์ค€
apt-get update
apt-get install -y mysql-server
service mysql start
apt-get install -y php7.2-mbstring php7.2-mysqli phpmyadmin
service apache2 restart

 

3. ์•„๋ž˜ ๋ช…๋ น์–ด ์ž…๋ ฅํ•ด์„œ ๊ด€๋ฆฌ์ž ์ง„์ž… (https://velog.io/@seungsang00/Ubuntu-%EC%9A%B0%EB%B6%84%ED%88%AC%EC%97%90-MySQL-%EC%84%A4%EC%B9%98%ED%95%98%EA%B8%B0) ์ฐธ๊ณ 

sudo /usr/bin/mysql -u root -p

 

4. ์•„๋ž˜์—์„œ ๋‚˜์˜ค๋Š” ๊ณ„์ • ์ •๋ณด๋กœ phpmyadmin ๋กœ๊ทธ์ธ

sudo cat /etc/mysql/debian.cnf

 

 

Troubleshooting

๊ถŒํ•œ ์˜ค๋ฅ˜ ๋ฐœ์ƒ์‹œ ๋‹ค์Œ ์ฐธ๊ณ : 

https://oziguyo.tistory.com/36

 

Access denied for user 'root@'@'localhost' ํ•ด๊ฒฐ๋ฐฉ๋ฒ•

Ubuntu์—์„œ mysql์˜ root๊ณ„์ • ๋กœ๊ทธ์ธ์ด ์•ˆ๋˜๋Š” ๊ฒฝ์šฐ ํ•ด๊ฒฐ๋ฐฉ๋ฒ• ! ubuntu๊ฐ™์€ ์ผ๋ถ€ ๋ฆฌ๋ˆ…์Šค ์‹œ์Šคํ…œ์—์„œ mysql์„ ์„ค์น˜ํ•˜๊ณ  $ mysql -u root -p ์œผ๋กœ ๋กœ๊ทธ์ธ ์‹œ๋„๋ฅผํ•˜๋ฉด 'ERROR 1698 (28000): Access denied for user 'root'@'localh

oziguyo.tistory.com

https://cjh5414.github.io/change-mysql-root-password-mac/

 

MySQL root password ๋ณ€๊ฒฝ

Jihun's Development Blog

cjh5414.github.io