Server๐Ÿงค

[Ubuntu] APM ์†Œ์Šค ์„ค์น˜(์ˆ˜๋™ ์„ค์น˜)ํ•˜๊ธฐ - 2 (MySQL)

yujindonut 2022. 3. 14. 04:56
728x90

๐ŸŒœํ•„์ˆ˜ ํŒจํ‚ค์ง€ ์„ค์น˜

& sudo su

/usr/local# apt-get update

/usr/local# apt-get install cmake

/usr/local# apt-get install libssl-dev

/usr/local# apt-get install libboost-all-dev

/usr/local# apt-get install libncurses5-dev libncursesw5-dev

 

/usr/local# apt-get install make

/usr/local# apt-get install gcc

/usr/local# apt-get install g++

/usr/local# apt-get install perl


๐ŸŒœ์†Œ์Šค์„ค์น˜ ํŒŒ์ผ ๋‹ค์šด๋กœ๋“œ ๋ฐ ์••์ถ•ํ•ด์ œ

/usr/local# wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.19.tar.gz

/usr/local# tar xvfz mysql-8.0.19.tar.gz


๐ŸŒœ Mysql ์„ค์น˜ (mysql-8.0.19)

/usr/local# cd mysql-8.0.19

/usr/local/mysql-8.0.19# mkdir dir_mysql

/usr/local/mysql-8.0.19# cd ..

/usr/local# cd src

/usr/local/src# sudo wget https://boostorg.jfrog.io/artifactory/main/release/1.70.0/source/boost_1_70_0.tar.gz

/usr/local/src# sudo tar xvfz boost_1_70_0.tar.gz

/usr/local/src# cd ..

/usr/local# cd /usr/local/mysql-8.0.19/dir_mysql

/usr/local/mysql-8.0.19/dir_mysql# cmake \.. \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/usr/local/mysql/data \-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DSYSCONFDIR=/etc \-DWITH_EXTRA_CHARSETS=all \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DDOWNLOAD_BOOST=1 \-DWITH_BOOST=/usr/local/src/boost_1_70_0

 

๐Ÿ’ข๐Ÿ’ข๐Ÿ’ขCMake Error at cmake/ssl.cmake:64 (MESSAGE):
  Please install the appropriate openssl developer package.
๐Ÿ’ขCall Stack (most recent call first):
  cmake/ssl.cmake:318 (FATAL_SSL_NOT_FOUND_ERROR)
  CMakeLists.txt:1191 (MYSQL_CHECK_SSL)

๐Ÿ’ขSee also "/usr/local/mysql-8.0.19/dir_mysql/CMakeFiles/CMakeOutput.log".
๐Ÿ’ขSee also "/usr/local/mysql-8.0.19/dir_mysql/CMakeFiles/CMakeError.log".

์ด ๋ฐ‘์— ๋‘๊ฐœ ์ž…๋ ฅํ–ˆ๋‹ค!!

๋”๋ณด๊ธฐ

apt-get install libssl-dev

apt-get install openssl

 

/usr/local/mysql-8.0.19/dir_mysql# make --->์—ฌ๊ธฐ์„œ ๊ผฌ๋ฐ• ํ•˜๋ฃจ๊ฐ€ ๊ฑธ๋ ธ๋‹ค..์ •ํ™•ํ•˜๊ฒŒ 8์‹œ๊ฐ„..

/usr/local/mysql-8.0.19/dir_mysql# make install


๐ŸŒœ Mysql DB์ดˆ๊ธฐํ™”

1. mysql ๊ทธ๋ฃน ๋ฐ ์œ ์ € ์ƒ์„ฑ

/usr/local/mysql-8.0.19/dir_mysql# groupadd mysql

/usr/local/mysql-8.0.19/dir_mysql# useradd -r -g mysql -s /bin/false mysql

2. ๋””๋ ‰ํ† ๋ฆฌ ์ƒ์„ฑ

/usr/local# cd mysql

/usr/local/mysql# mkdir mysql-files (์ด๋ฆ„ ์•„๋ฌด๊ฑฐ๋‚˜ ์ƒ๊ด€์—†์Œ)

3. ๊ถŒํ•œ์ฃผ๊ธฐ

/usr/local/mysql# chown -R mysql:mysql /usr/local/mysql

/usr/local/mysql# chown mysql:mysql mysql-files

/usr/local/mysql# chmod 750 mysql-files

4. ๊ธฐ๋ณธ DB ์ƒ์„ฑ

/usr/local/mysql# bin/mysqld --initialize --user=mysql \

--basedir=/usr/local/mysql \

--datadir=/usr/local/mysql/data

์ž„์‹œ๋น„๋ฐ€๋ฒˆํ˜ธ ์ƒ์„ฑ๋จ


๐ŸŒœ Mysql ์„œ๋ฒ„ ์‹คํ–‰ ๋ฐ ๋น„๋ฐ€๋ฒˆํ˜ธ ์žฌ์„ค์ •

1. MySQL ์„œ๋ฒ„ ์‹คํ–‰

/usr/local/mysql# bin/mysqld_safe --user=mysql &

#bin/mysql -u root -p

#Enter password: ๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ

๋‹ค๋ฅธํ„ฐ๋ฏธ๋„ ์ฐฝ์—์„œ

$ ps -ef | grep mysqld

-->์‹คํ–‰๋˜๊ณ  ์žˆ๋Š” ๊ฒƒ์ด ๋ณด์ž„

2. ๋น„๋ฐ€๋ฒˆํ˜ธ ์žฌ์„ค์ • ๋ฐ ์„œ๋ฒ„ ์ข…๋ฃŒ

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password';

-->์—ฌ๊ธฐ์—๋Š” ๊ฐ์ž์˜ ์ž๊ธฐ ๋น„๋ฐ€๋ฒˆํ˜ธ ๋„ฃ์œผ๋ฉด ๋จ ''๋”ฐ์˜ดํ‘œ๋ฅผ ์žŠ์ง€๋ง์ž!

mysql> exit

/usr/local/mysql# bin/mysqladmin -u root -p shutdown

 


๐ŸŒœ ๋ช…๋ น์–ด๋กœ MySQL Server ์‹œ์ž‘ํ•˜๊ณ  ์ข…๋ฃŒํ•˜๋Š” ๋ฐฉ๋ฒ•

$ service mysql start

$ service mysql stop

$ service mysql restart //์„œ๋ฒ„๋ฅผ ์ค‘์ง€ํ–ˆ๋‹ค๊ฐ€ ๋‹ค์‹œ ์‹œ์ž‘

$ service mysql status //์„œ๋ฒ„ ์ƒํƒœ ํ™•์ธ. ๋‚˜๊ฐ€๋ ค๋ฉด q

 

๋ช…๋ น์–ด ์œ„์น˜ : /usr/local/mysql


$ bin/mysqld_safe --user=mysql &

์ด๊ฑฐ ์ž…๋ ฅํ•˜๋ฉด ์•„๋ž˜์™€ ๊ฐ™์€ ์˜ค๋ฅ˜๋ฉ”์„ธ์ง€๊ฐ€ ๊ณ„์† ๋‚ฌ๋Š”๋ฐ, ๊ทธ๋ƒฅ ๋ฐ‘์— ๋ฌธ๊ตฌ ๊ณ„์† ์ง„ํ–‰ํ•˜๋ฉด ์–ด๋А์ˆœ๊ฐ„ ๋œ๋‹ค..

Logging to '/usr/local/mysql/data/ubuntu.err'.
2022-03-14T01:54:24.832436Z mysqld_safe Directory '/usr/local/mysql/mysql' for UNIX socket file don't exists.

root@ubuntu:/usr/local/mysql# bin/mysqld_safe --user=mysql &
[1] 3986
root@ubuntu:/usr/local/mysql# 2022-03-15T00:11:21.681589Z mysqld_safe Logging to '/usr/local/mysql/data/ubuntu.err'.
2022-03-15T00:11:21.721743Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

#bin/mysql -u root -p

$ ps -ef | grep mysqld

$ bin/mysql -u root -p

 

๋ฐ”๋ณด ๊ฐ™์•˜๋˜๊ฒŒ ์—ฌ๊ธฐ์„œ ๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ ์ž˜๋ชปํ•ด๋†“๊ณ , ๋‹ค๋ฅธ๊ฒŒ ์˜ค๋ฅ˜๋ฉ”์„ธ์ง€์ธ์ค„์•Œ๊ณ ,, ๊ทธ๋ƒฅ ๊ณ„์† ์ฒ˜์Œ๋ถ€ํ„ฐ ์‚ฝ์งˆํ–ˆ๋‹ค ใ… ใ… ..

๊ทธ๋ƒฅ ๋น„๋ฐ€๋ฒˆํ˜ธ ๋งž๊ฒŒ ๋‚˜์™”์œผ๋ฉด, ๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ์„ ๋ช‡๋ฒˆ์”ฉ ํ•ด๋ณด๊ธฐ!!!!!!!!!!!!

๋น„๋ฐ€๋ฒˆํ˜ธ๊นŒ์ง€ ๋‚˜์™”์œผ๋ฉด ๋‹ค์‹œ ์ฒ˜์Œ๋ถ€ํ„ฐ ๊นŒ๋Š” ๊ทธ๋Ÿฐ ์‚ฝ์งˆ์€ ์•ˆํ•ด๋„ ๋˜๋Š”๋“ฏ ํ•˜๋‹ค

๋น„๋ฐ€๋ฒˆํ˜ธ ์žฌ์„ค์ • ๋ฐ ์„œ๋ฒ„ ์ข…๋ฃŒ

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password'; 

 

 

 

 

์ฐธ๊ณ ์‚ฌ์ดํŠธ

https://salix97.tistory.com/141

 

Ubuntu 18.04 + Apache 2.4.41 + Mysql 8.0.19 ์ˆ˜๋™์„ค์น˜ํ•˜๊ธฐ

Ubuntu 18.04 OS ์œ„์— Apache 2.4.41 ์ปดํŒŒ์ผ ์„ค์น˜๋ฅผ ์™„๋ฃŒํ–ˆ๋‹ค. PHP ๋ฅผ ์„ค์น˜ํ•˜๊ธฐ ์ „์— Mysql ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ฅผ ์„ค์น˜ํ•˜๋ ค๊ณ  ํ•œ๋‹ค. ์ž์„ธํ•œ ๋‚ด์šฉ์€ ํ‘œ์ค€ ์†Œ์Šค ๋ฐฐํฌ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ MySQL ์„ค์น˜ ๋งํฌ ์ฐธ์กฐ : https://dev.mys..

salix97.tistory.com

https://11-20.tistory.com/9

 

[RC] Ubuntu 20.04 - MySql ์†Œ์Šค ์„ค์น˜ํ•˜๊ธฐ (APM # 2)

[RC] Ubuntu 20.04 - Apache ์†Œ์Šค ์„ค์น˜ํ•˜๊ธฐ (APM # 1) [RC] Ubuntu 20.04 - MySql ์†Œ์Šค ์„ค์น˜ํ•˜๊ธฐ (APM # 2) ์ง€๋‚œ ํฌ์Šคํ„ฐ์— ์ด์–ด์„œ ์ด๋ฒˆ์—๋Š” MySql์„ ์†Œ์Šค ์„ค์น˜ํ•ด๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค. ์šฐ์„  ์•„๋ž˜์˜ ํŒจํ‚ค์ง€๋ฅผ ๋จผ์ € ์„ค์น˜ํ•ด์ฃผ์„ธ..

11-20.tistory.com

https://yeni-days.tistory.com/7?category=1020921 

 

[Ubuntu] Ubuntu-20.04์— APM ์†Œ์Šค ์„ค์น˜(์ˆ˜๋™ ์„ค์น˜)ํ•˜๊ธฐ - 2 (MySQL)

2021.11.25 - [Ubuntu] - [Ubuntu] Ubuntu-20.04์— APM ์†Œ์Šค ์„ค์น˜(์ˆ˜๋™ ์„ค์น˜)ํ•˜๊ธฐ - 1 (Apache, Mysql, php) [Ubuntu] Ubuntu-20.04์— APM ์†Œ์Šค ์„ค์น˜(์ˆ˜๋™ ์„ค์น˜)ํ•˜๊ธฐ - 1 (Apache, Mysql, php) ์†Œ์Šค์„ค์น˜ ์†Œ์Šค์„ค์น˜,..

yeni-days.tistory.com

 

728x90