phpMyadmin & WEB 연동

📌 Package Update & Apache2 Install

 

root@soohyun:/var/www/html#  apt-get update

root@soohyun:/var/www/html#  apt-get -y install apache2

 

📌 PORT OPEN

 

👉🏻 3306 → 80 으로 변경해서 설정하시면 되요.

👉🏻 이하 사진처럼 하되, 저는 80번을 미리 열어놨어요.

 

 

 

 

 

 

 

📌 SERVICE START

 

root@soohyun:/var/www/html# service apache2 start

 

📌 WGET INSTALL

 

root@soohyun:/var/www/html# apt-get install wget

 

📌 PHPMYADMIN INSTALL

 

root@soohyun:/var/www/html# apt-get install phpmyadmin -y

Configure database for phpmyadmin with dbconfig-common? [yes/no] yes

Please provide a password for phpmyadmin to register with the database server.
If left blank, a random password will be generated.

MySQL application password for phpmyadmin: [password]

Password confirmation: [password]

Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
Please choose the web server that should be automatically configured to run phpMyAdmin.

1. apache2
2. lighttpd

(Enter the items you want to select, separated by spaces.)

Web server to reconfigure automatically: 1

 

📌 PHPMYADMIN INSTALL & NAME CHANGE & UNZIP

 

phpMyAdmin

 

 

root@soohyun:/var/www/html# wget https://files.phpmyadmin.net/phpMyAdmin/5.1.1/phpMyAdmin-5.1.1-all-languages.zip

root@soohyun:/# ls -l

total 14508
lrwxrwxrwx 1 root root 7 Jan 19 2021 bin -> usr/bin
drwxr-xr-x 2 root root 4096 Apr 15 2020 boot
drwxr-xr-x 5 root root 360 Dec 25 22:40 dev
drwxr-xr-x 1 root root 4096 Dec 25 23:19 etc
drwxr-xr-x 1 root root 4096 Jan 23 2021 home
lrwxrwxrwx 1 root root 7 Jan 19 2021 lib -> usr/lib
lrwxrwxrwx 1 root root 9 Jan 19 2021 lib32 -> usr/lib32
lrwxrwxrwx 1 root root 9 Jan 19 2021 lib64 -> usr/lib64
lrwxrwxrwx 1 root root 10 Jan 19 2021 libx32 -> usr/libx32
drwxr-xr-x 2 root root 4096 Jan 19 2021 media
drwxr-xr-x 2 root root 4096 Jan 19 2021 mnt
drwxr-xr-x 2 root root 4096 Jan 19 2021 opt
-rw-r--r-- 1 root root 14801905 Jun 4 2021 phpMyAdmin-5.1.1-all-languages.zip

root@soohyun:/# unzip ./phpMyAdmin-5.1.1-all-languages.zip

root@soohyun:/# mv ./phpMyAdmin-5.1.1-all-languages ./myadmin

root@soohyun:/# mv ./myadmin /var/www/html

 

📌 SERVICE RESTART

 

root@soohyun:/# service apache2 restart

 

📌 CONNECT

 

👉🏻 URL → [YOUR DOMAIN OR IP]/myadmin