안녕하세요?
데비안9에 맞는 웹서버 설치 과정을 작성하고 있습니다.
시작합니다.
1. mariadb 서버 및 클라이언트 설치 |
# mysql 이름이 mariadb 로 바뀌었습니다. root@AOL-Debian:~# apt install mariadb-server mariadb-client Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: galera-3 gawk libaio1 libatomic1 libcgi-fast-perl libcgi-pm-perl libdbd-mysql-perl libdbi-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl libjemalloc1 liblwp-mediatypes-perl libmariadbclient18 libmpfr4 libreadline5 libsigsegv2 libterm-readkey-perl libtimedate-perl liburi-perl lsof mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server-10.1 mariadb-server-core-10.1 mysql-common psmisc rsync socat Suggested packages: gawk-doc libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl libdata-dump-perl libipc-sharedcache-perl libwww-perl mailx mariadb-test netcat-openbsd tinyca The following NEW packages will be installed: galera-3 gawk libaio1 libatomic1 libcgi-fast-perl libcgi-pm-perl libdbd-mysql-perl libdbi-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl libjemalloc1 liblwp-mediatypes-perl libmariadbclient18 libmpfr4 libreadline5 libsigsegv2 libterm-readkey-perl libtimedate-perl liburi-perl lsof mariadb-client mariadb-client-10.1 mariadb-client-core-10.1 mariadb-common mariadb-server mariadb-server-10.1 mariadb-server-core-10.1 mysql-common psmisc rsync socat 0 upgraded, 37 newly installed, 0 to remove and 6 not upgraded. Need to get 25.0 MB of archives. After this operation, 161 MB of additional disk space will be used. Do you want to continue? [Y/n] |
# mariadb 를 구동하는 mysql 계정이 네트워크 권한을 갖게 합니다. root@AOL-Debian:~# adduser mysql aid_inet Adding user `mysql' to group `aid_inet' ... Adding user mysql to group aid_inet Done. |
# mysql 을 시작합니다. root@AOL-Debian:~# service mysql start [ ok ] Starting MariaDB database server: mysqld. |
2. phpmyadmin 설치 (apache2, php7) |
# phpmyadmin 을 설치합니다. root@AOL-Debian:~# apt install phpmyadmin Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: apache2 apache2-bin apache2-data apache2-utils dbconfig-common dbconfig-mysql javascript-common libapache2-mod-php7.0 libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap libgd3 libjbig0 libjs-jquery libjs-sphinxdoc libjs-underscore liblua5.2-0 libtiff5 libxpm4 libzip4 php php-bz2 php-common php-curl php-gd php-mbstring php-mysql php-pear php-php-gettext php-phpseclib php-tcpdf php-xml php-zip php7.0 php7.0-bz2 php7.0-cli php7.0-common php7.0-curl php7.0-gd php7.0-json php7.0-mbstring php7.0-mysql php7.0-opcache php7.0-readline php7.0-xml php7.0-zip ssl-cert Suggested packages: www-browser apache2-doc apache2-suexec-pristine | apache2-suexec-custom libgd-tools php-libsodium php-mcrypt php-gmp php5-imagick openssl-blacklist Recommended packages: php5-gd php5-mcrypt The following NEW packages will be installed: apache2 apache2-bin apache2-data apache2-utils dbconfig-common dbconfig-mysql javascript-common libapache2-mod-php7.0 libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap libgd3 libjbig0 libjs-jquery libjs-sphinxdoc libjs-underscore liblua5.2-0 libtiff5 libxpm4 libzip4 php php-bz2 php-common php-curl php-gd php-mbstring php-mysql php-pear php-php-gettext php-phpseclib php-tcpdf php-xml php-zip php7.0 php7.0-bz2 php7.0-cli php7.0-common php7.0-curl php7.0-gd php7.0-json php7.0-mbstring php7.0-mysql php7.0-opcache php7.0-readline php7.0-xml php7.0-zip phpmyadmin ssl-cert 0 upgraded, 49 newly installed, 0 to remove and 6 not upgraded. Need to get 19.2 MB of archives. After this operation, 69.1 MB of additional disk space will be used. Do you want to continue? [Y/n] |
이후 결과 내용입니다.
dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf Replacing config file /etc/dbconfig-common/phpmyadmin.conf with new version Replacing config file /etc/phpmyadmin/config-db.php with new version checking privileges on database phpmyadmin for phpmyadmin@localhost: user creation needed. granting access to database phpmyadmin for phpmyadmin@localhost: success. verifying access for phpmyadmin@localhost: success. creating database phpmyadmin: success. verifying database phpmyadmin exists: success. populating database via sql... done. dbconfig-common: flushing administrative password Setting up php (1:7.0+49) ... Processing triggers for libc-bin (2.24-11+deb9u4) ... Processing triggers for systemd (215-17+deb8u6) ... |
3. phpmyadmin 연동 |
# apache2.conf 파일을 수정합니다. root@AOL-Debian:~# nano /etc/apache2/apache2.conf # phpmyadmin Include /etc/phpmyadmin/apache.conf |
# 서비스를 재시작합니다. root@AOL-Debian:~# service apache2 restart [....] Restarting Apache httpd web server: apache2AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1. Set the 'ServerName' directive globally to suppress this message . ok |
# 서버 네임을 모르겠다는 에러를 아래와 같이 해결합니다. root@AOL-Debian:~# nano /etc/apache2/apache2.conf # server name ServerName localhost |
# 정상적으로 재시작 됩니다. root@AOL-Debian:~# service apache2 restart [ ok ] Restarting Apache httpd web server: apache2. root@AOL-Debian:~# |
4. mariadb db 테이블 변경 |
초기에 비밀번호를 설정하지 않아서 root 로 로그인이 될것 같지만, 되지 않습니다.
root@AOL-Debian:~# mysql -u root -p # 비밀번호는 공백입니다. Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 56 Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1 Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. # db mysql 을 사용합니다. MariaDB [(none)]> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed # user 테이블 root 계정에 대해 plugin 부분을 공백으로 처리합니다. MariaDB [mysql]> update user set plugin='' where user='root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 # PASSWORD('') 부분에 원하는 비밀번호를 적으시길 바랍니다. # root 계정에 대해 업데이트 하는 부분입니다. MariaDB [mysql]> update user set password=PASSWORD('djj9405') where user='root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 # 권한을 재로딩합니다. MariaDB [mysql]> flush privileges; Query OK, 0 rows affected (0.00 sec) # 연결을 종료합니다. MariaDB [mysql]> exit Bye |
http://u5pvr_ip_addr/phpmyadmin
다시 로그인하게 되면 아래와 같이 잘 로그인 됩니다.
보안 관련하여 필요할 경우에만 phpmyadmin 을 열어두시길 바랍니다.
한편, 외부에서 DB 접근을 하는 경우 root 계정은 socket 연결만 허용하시는게 좋습니다.
감사합니다.
'컴퓨터에 대한 이래저래' 카테고리의 다른 글
VMware Workstation 16 Pro 16.1.2 Build 17966106 RePack 다운로드 (0) | 2021.11.05 |
---|---|
토렌트 쓰면 반드시 읽어야 되는 글 (0) | 2021.11.05 |
배치파일을 강제로 관리자 권한 얻기 (bat파일) (0) | 2021.11.03 |
CFF Explorer (0) | 2021.11.03 |
CentOS 6.8 한글 설치 및 한영키 설정 방법 (0) | 2021.11.03 |