리눅스 phpMyAdmin 설치 (수동)

phpMyAdmin 설치 (git)

1 다운로드 및 업로드

• http://www.phpmyadmin.net/ 접속
• [Download 4.0.9] 클릭하여 phpMyAdmin-4.0.9-all-languages.zip 다운로드(8 MB)
• zip파일을 대상 서버의 DOCUMENT_ROOT 상위폴더에 업로드

2 압축 해제

[root@jmnote ~]# cd /var/www/
[root@jmnote www]# ll *.zip
-rw-r--r--  1 root root 8349983 Nov 30 02:01 phpMyAdmin-4.0.9-all-languages.zip

[root@jmnote www]# unzip phpMyAdmin-4.0.9-all-languages.zip
... (생략)
  inflating: phpMyAdmin-4.0.9-all-languages/view_create.php  
  inflating: phpMyAdmin-4.0.9-all-languages/view_operations.php  
  inflating: phpMyAdmin-4.0.9-all-languages/webapp.php

[root@jmnote www]# ll
total 8188
drwxr-xr-x  2 root root    4096 Nov 25  2012 cgi-bin
drwxr-xr-x  3 root root    4096 Nov 27 01:30 error
drwxr-xr-x 34 root root    4096 Jul 14  2011 html
drwxr-xr-x  3 root root    4096 Nov 27 01:31 icons
drwxr-xr-x  9 root root    4096 Nov  4 12:25 phpMyAdmin-4.0.9-all-languages
-rw-r--r--  1 root root 8349983 Nov 30 02:01 phpMyAdmin-4.0.9-all-languages.zip

3 아파치 설정

httpd.conf 수정

/etc/httpd/conf/httpd.conf 파일에서 DocumentRoot를 찾아 그 아랫줄에 Alias 행 추가

[root@jmnote ~]# vi /etc/httpd/conf/httpd.conf

DocumentRoot "/var/www/html"
Alias /phpMyAdmin /var/www/phpMyAdmin-4.0.9-all-languages/

아파치 재시작

[root@jmnote ~]# service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]

4 웹으로 접속

• http://도메인/phpMyAdmin 으로 접속
• php-mbstring이 없다면 다음과 같은 오류가 발생할 수 도 있다.

phpMyAdmin - Error
The mbstring extension is missing. Please check your PHP configuration.

→ php-mbstring 설치 필요

5 설정

[root@jmnote www]# cd phpMyAdmin
[root@jmnote phpMyAdmin]# mkdir config
[root@jmnote phpMyAdmin]# cd config
[root@jmnote config]# cp ../config.sample.inc.php config.inc.php
[root@jmnote config]# ll
total 4
-rw-r--r-- 1 root root 3889 Dec  2 03:26 config.inc.php

6 같이 보기

• phpMyAdmin
• The configuration file now needs a secret passphrase (blowfish_secret).
• The mbstring extension is missing. Please check your PHP configuration. (php-mbstring 설치)
• The mcrypt extension is missing. Please check your PHP configuration. (php-mcrypt 설치)

7 참고 자료

• http://wiki.phpmyadmin.net/pma/Quick_Install