๐ŸŒ ์ธํ”„๋ผ/NHN Cloud

NHN Cloud ์ธ์Šคํ„ด์Šค์— MySQL ์„ค์น˜ํ•˜๊ธฐ (2) - Yum ์ด์šฉ

๋ฏธ์ธ์ฃผ 2023. 1. 18. 22:39

โœ… ๊ณต์‹๋ฌธ์„œ

https://docs.nhncloud.com/ko/TOAST/ko/Overview/

 

โฌ‡๏ธ MySQL ์„ค์น˜ ์ „์— ์ธ์Šคํ„ด์Šค ์ƒ์„ฑํ•˜๋Š” ๋ฐฉ๋ฒ• โฌ‡๏ธ

2023.01.08 - [์ธํ”„๋ผ/NHN Cloud] - NHN Cloud ์ธ์Šคํ„ด์Šค ์ƒ์„ฑํ•˜๊ธฐ


์ธ์Šคํ„ด์Šค ํ™˜๊ฒฝ

  • OS : CentOS 7.9
  • ์•„ํ‚คํ…์ณ: x86_64

 

0. ์„ค์น˜ ์ „ ํ™•์ธ

์ธ์Šคํ„ด์Šค์— MySQL์„ ์ฒ˜์Œ ์„ค์น˜ํ•œ๋‹ค๋Š” ๊ฐ€์ •์œผ๋กœ ์„ค์น˜๋ฅผ ์ง„ํ–‰ํ•œ๋‹ค.

  • ์„ค์น˜ ์—ฌ๋ถ€ ํ™•์ธ
rpm -qa | grep mysql


์•„๋ž˜์™€ ๊ฐ™์ด ๋‚˜์˜ค๋ฉด ์„ค์น˜๊ฐ€ ๋˜์–ด ์žˆ๋Š” ๊ฒƒ์ด๋‹ค.

์žฌ์„ค์น˜๋ฅผ ํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” ์‚ญ์ œ๋ฅผ ๋จผ์ € ํ•˜๊ณ  ์„ค์น˜๋ฅผ ์ง„ํ–‰ํ•œ๋‹ค.

yum remove mysql-server

 

1. ์„ค์น˜ ๊ณผ์ •

( 1 / 8 ) ์ธ์Šคํ„ด์Šค์— SSH ๋ฐฉ์‹์œผ๋กœ ์ ‘์†

ssh -i [ํ‚คํŽ˜์–ด์ด๋ฆ„.pem] centos@[ํ”Œ๋กœํŒ…IP]

 

( 2 / 8 ) yum์„ ํ†ตํ•ด ๋‹ค์šด๋กœ๋“œ

sudo yum -y install https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm
  • yum repository์— ๋‹ค์šด ๋ฐ›์€ MySQL์ด ์ถ”๊ฐ€๋˜์—ˆ๋Š”์ง€ ํ™•์ธ
yum repolist enabled | grep "mysql.*-community.*"

๐Ÿ’ก yum์ด๋ž€?

2023.01.13 - [ํ”„๋กœ๊ทธ๋ž˜๋ฐ/Linux] - Yum์ด๋ž€? ๊ฐœ๋…, ์‚ฌ์šฉ๋ฒ• ๋ฐ ๋™์ž‘๋ฐฉ์‹์— ๋Œ€ํ•ด์„œ

 

( 3 / 8 ) MySQL ์„ค์น˜

sudo yum install mysql-community-server

 

( 4 / 8 ) MySQL version ํ™•์ธ

mysql --version

 

( 5 / 8 ) MySQL ์‹œ์ž‘

sudo systemctl start mysqld

 

( 6 / 8 ) ์ž„์‹œ๋น„๋ฐ€๋ฒˆํ˜ธ ํ™•์ธ

sudo grep '์ž„์‹œ๋น„๋ฐ€๋ฒˆํ˜ธ' /var/log/mysqld.log

 

( 7 / 8 ) root ๊ณ„์ •์— ์ž„์‹œ๋น„๋ฐ€๋ฒˆํ˜ธ๋กœ MySQL ์ ‘์†

mysql -u root -p

 

( 8 / 8 ) root ๊ณ„์ •์˜ ์ž„์‹œ๋น„๋ฐ€๋ฒˆํ˜ธ ๋ณ€๊ฒฝ

ALTER USER 'root'@'localhost' IDENTIFIED BY '[๋ณ€๊ฒฝํ•  ๋น„๋ฐ€๋ฒˆํ˜ธ]';

 

2. ์„ค์น˜ ๊ฒฐ๊ณผ

sudo systemctl start mysqld
sudo systemctl status mysqld