달력

11

« 2024/11 »

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
2010. 3. 5. 15:16

phpMyAdmin 설치하기 DB자라/MySQL2010. 3. 5. 15:16

없길래 설치 -_-;;


오늘날짜기준으로 다운 주소http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.2.5/phpMyAdmin-3.2.5-all-languages.tar.gz?use_mirror=cdnetworks-kr-2

[root@zalbang public_html]# wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.2.5/phpMyAdmin-3.2.5-all-languages.tar.gz?use_mirror=cdnetworks-kr-2
--2010-03-05 15:03:48--  http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.2.5/phpMyAdmin-3.2.5-all-languages.tar.gz?use_mirror=cdnetworks-kr-2
Resolving downloads.sourceforge.net... 216.34.181.59
Connecting to downloads.sourceforge.net|216.34.181.59|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://cdnetworks-kr-2.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.2.5/phpMyAdmin-3.2.5-all-languages.tar.gz [following]
--2010-03-05 15:03:50--  http://cdnetworks-kr-2.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.2.5/phpMyAdmin-3.2.5-all-languages.tar.gz
Resolving cdnetworks-kr-2.dl.sourceforge.net... 211.39.135.163
Connecting to cdnetworks-kr-2.dl.sourceforge.net|211.39.135.163|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3709673 (3.5M) [application/x-gzip]
Saving to: `phpMyAdmin-3.2.5-all-languages.tar.gz'

100%[==========================================================>] 3,709,673   15.8M/s   in 0.2s

2010-03-05 15:03:50 (15.8 MB/s) - `phpMyAdmin-3.2.5-all-languages.tar.gz' saved [3709673/3709673]

[root@zalbang public_html]# ll
total 3756
-rw-r--r-- 1 root root 3709673 Jan 10 21:22 phpMyAdmin-3.2.5-all-languages.tar.gz

[root@zalbang public_html]# tar xzpf phpMyAdmin-3.2.5-all-languages.tar.gz

[root@zalbang public_html]# ll
total 3760
drwxr-xr-x 10 root root    4096 Jan 10 21:17 phpMyAdmin-3.2.5-all-languages
-rw-r--r--  1 root root 3709673 Jan 10 21:22 phpMyAdmin-3.2.5-all-languages.tar.gz
[root@zalbang public_html]# cd phpMyAdmin-3.2.5-all-languages
[root@zalbang phpMyAdmin-3.2.5-all-languages]# ll
total 1492
-rw-r--r--  1 root root  10886 Jan 10 21:17 browse_foreigners.php
-rw-r--r--  1 root root   4354 Jan 10 21:17 bs_change_mime_type.php
-rw-r--r--  1 root root   1797 Jan 10 21:17 bs_disp_as_mime_type.php
-rw-r--r--  1 root root   2368 Jan 10 21:17 bs_play_media.php
-rw-r--r--  1 root root    845 Jan 10 21:17 calendar.php
-rw-r--r--  1 root root  14374 Jan 10 21:17 ChangeLog
-rw-r--r--  1 root root   3613 Jan 10 21:17 changelog.php
-rw-r--r--  1 root root    520 Jan 10 21:17 chk_rel.php
-rw-r--r--  1 root root   2165 Jan 10 21:17 config.sample.inc.php
drwxr-xr-x  3 root root   4096 Jan 10 21:17 contrib
-rw-r--r--  1 root root    169 Jan 10 21:17 CREDITS
-rw-r--r--  1 root root   1507 Jan 10 21:17 db_create.php
-rw-r--r--  1 root root  10469 Jan 10 21:17 db_datadict.php
-rw-r--r--  1 root root   2454 Jan 10 21:17 db_export.php
-rw-r--r--  1 root root    491 Jan 10 21:17 db_import.php
-rw-r--r--  1 root root  27139 Jan 10 21:17 db_operations.php
-rw-r--r--  1 root root   7439 Jan 10 21:17 db_printview.php
-rw-r--r--  1 root root  30632 Jan 10 21:17 db_qbe.php
-rw-r--r--  1 root root  13151 Jan 10 21:17 db_search.php
-rw-r--r--  1 root root   1008 Jan 10 21:17 db_sql.php
-rw-r--r--  1 root root  26671 Jan 10 21:17 db_structure.php
-rw-r--r--  1 root root   3365 Jan 10 21:17 docs.css
-rw-r--r--  1 root root 235897 Jan 10 21:17 Documentation.html
-rw-r--r--  1 root root 167660 Jan 10 21:17 Documentation.txt
-rw-r--r--  1 root root   2193 Jan 10 21:17 error.php
-rw-r--r--  1 root root  24954 Jan 10 21:17 export.php
-rw-r--r--  1 root root  18902 Jan 10 21:17 favicon.ico
-rw-r--r--  1 root root  13822 Jan 10 21:17 import.php
-rw-r--r--  1 root root   6834 Jan 10 21:17 index.php
-rw-r--r--  1 root root    179 Jan 10 21:17 INSTALL
drwxr-xr-x  3 root root   4096 Jan 10 21:17 js
drwxr-xr-x  2 root root   4096 Jan 10 21:17 lang
drwxr-xr-x 10 root root   4096 Jan 10 21:17 libraries
-rw-r--r--  1 root root  18011 Jan 10 21:17 LICENSE
-rw-r--r--  1 root root    500 Jan 10 21:17 license.php
-rw-r--r--  1 root root  13416 Jan 10 21:17 main.php
-rw-r--r--  1 root root  25891 Jan 10 21:17 navigation.php
-rw-r--r--  1 root root  27454 Jan 10 21:17 pdf_pages.php
-rw-r--r--  1 root root  52880 Jan 10 21:17 pdf_schema.php
-rw-r--r--  1 root root    468 Jan 10 21:17 phpinfo.php
-rw-r--r--  1 root root   1133 Jan 10 21:17 phpmyadmin.css.php
drwxr-xr-x  5 root root   4096 Jan 10 21:17 pmd
-rw-r--r--  1 root root   9895 Jan 10 21:17 pmd_common.php
-rw-r--r--  1 root root   1917 Jan 10 21:17 pmd_display_field.php
-rw-r--r--  1 root root  18556 Jan 10 21:17 pmd_general.php
-rw-r--r--  1 root root    880 Jan 10 21:17 pmd_help.php
-rw-r--r--  1 root root   3773 Jan 10 21:17 pmd_pdf.php
-rw-r--r--  1 root root   4041 Jan 10 21:17 pmd_relation_new.php
-rw-r--r--  1 root root   2020 Jan 10 21:17 pmd_relation_upd.php
-rw-r--r--  1 root root   2108 Jan 10 21:17 pmd_save_pos.php
-rw-r--r--  1 root root   1063 Jan 10 21:17 print.css
-rw-r--r--  1 root root   8280 Jan 10 21:17 querywindow.php
-rw-r--r--  1 root root   2608 Jan 10 21:17 README
-rw-r--r--  1 root root    758 Jan 10 21:17 README.VENDOR
-rw-r--r--  1 root root     29 Jan 10 21:17 RELEASE-DATE-3.2.5
-rw-r--r--  1 root root     26 Jan 10 21:17 robots.txt
drwxr-xr-x  2 root root   4096 Jan 10 21:17 scripts
-rw-r--r--  1 root root   7637 Jan 10 21:17 server_binlog.php
-rw-r--r--  1 root root   2698 Jan 10 21:17 server_collations.php
-rw-r--r--  1 root root  13514 Jan 10 21:17 server_databases.php
-rw-r--r--  1 root root   4743 Jan 10 21:17 server_engines.php
-rw-r--r--  1 root root   1667 Jan 10 21:17 server_export.php
-rw-r--r--  1 root root    506 Jan 10 21:17 server_import.php
-rw-r--r--  1 root root  98056 Jan 10 21:17 server_privileges.php
-rw-r--r--  1 root root   2951 Jan 10 21:17 server_processlist.php
-rw-r--r--  1 root root    615 Jan 10 21:17 server_sql.php
-rw-r--r--  1 root root  24593 Jan 10 21:17 server_status.php
-rw-r--r--  1 root root   2252 Jan 10 21:17 server_variables.php
drwxr-xr-x  4 root root   4096 Jan 10 21:17 setup
-rw-r--r--  1 root root    355 Jan 10 21:17 show_config_errors.php
-rw-r--r--  1 root root  26912 Jan 10 21:17 sql.php
-rw-r--r--  1 root root   8185 Jan 10 21:17 tbl_addfield.php
-rw-r--r--  1 root root   7263 Jan 10 21:17 tbl_alter.php
-rw-r--r--  1 root root  53578 Jan 10 21:17 tbl_change.php
-rw-r--r--  1 root root   9830 Jan 10 21:17 tbl_create.php
-rw-r--r--  1 root root   2618 Jan 10 21:17 tbl_export.php
-rw-r--r--  1 root root    655 Jan 10 21:17 tbl_import.php
-rw-r--r--  1 root root   8005 Jan 10 21:17 tbl_indexes.php
-rw-r--r--  1 root root   2488 Jan 10 21:17 tbl_move_copy.php
-rw-r--r--  1 root root  26634 Jan 10 21:17 tbl_operations.php
-rw-r--r--  1 root root  16708 Jan 10 21:17 tbl_printview.php
-rw-r--r--  1 root root  23473 Jan 10 21:17 tbl_relation.php
-rw-r--r--  1 root root  15425 Jan 10 21:17 tbl_replace.php
-rw-r--r--  1 root root   4922 Jan 10 21:17 tbl_row_action.php
-rw-r--r--  1 root root  16257 Jan 10 21:17 tbl_select.php
-rw-r--r--  1 root root    948 Jan 10 21:17 tbl_sql.php
-rw-r--r--  1 root root  31716 Jan 10 21:17 tbl_structure.php
drwxr-xr-x  4 root root   4096 Jan 10 21:17 themes
-rw-r--r--  1 root root   1299 Jan 10 21:17 themes.php
-rw-r--r--  1 root root    235 Jan 10 21:17 TODO
-rw-r--r--  1 root root   1688 Jan 10 21:17 transformation_overview.php
-rw-r--r--  1 root root   3734 Jan 10 21:17 transformation_wrapper.php
-rw-r--r--  1 root root   9053 Jan 10 21:17 translators.html
-rw-r--r--  1 root root   4622 Jan 10 21:17 user_password.php
-rw-r--r--  1 root root   5412 Jan 10 21:17 view_create.php
-rw-r--r--  1 root root   1132 Jan 10 21:17 webapp.php
[root@zalbang phpMyAdmin-3.2.5-all-languages]#


다음부터는 퍼왔다... 당췌 뭐 쓰기 귀찮아서 ㅋ

phpMyAdmin 디렉토리 안에 있는 config.sample.inc.php 파일을 config.inc.php 로 변경합니다.
[root@ruo91 ~]# cd /usr/local/src/myadmin
[root@ruo91 ~]# mv config.sample.inc.php config.inc.php

config.inc.php 파일의 아래 두가지 내용을 수정합니다.
[root@ruo91 ~]# vi config.inc.php
/* phpMyAdmin 로그인 인증을 쿠키로 할때 사용할 값을 적어줍니다.
*  인증 방식을 http 로 할경우 필요 없음..
*/
$cfg['blowfish_secret'] = 'ruo91phpMyAdmincookie';

/* 로그인 인증을 선택합니다. 기본값은 cookie 이며 보안상 http 로 설정할것을 권장합니다. */
$cfg['Servers'][$i]['auth_type'] = 'http';

아파치에서 phpMyAdmin 을 알리아스(Alias)를 걸어 줍니다.
<VirtualHost *:80>
    ServerName www.yongbok.net
    ServerAdmin ruo91@yongbok.net
    ServerAlias yongbok.com yongbok.net www.yongbok.com www.yongbok.net
    DocumentRoot /home/www
    ErrorLog /home/apache2-log/www-error.log
    LogLevel warn
    CustomLog /home/apache2-log/www-access.log combined
    ErrorDocument 403 http://www.yongbok.net/error/permission
    ErrorDocument 404 http://www.yongbok.net/error/
    Alias /phpMyAdmin "/usr/local/src/myadmin"
    Alias /myadmin "/usr/local/src/myadmin"
    <Directory "/home/www">
       Options FollowSymLinks
       AllowOverride FileInfo AuthConfig
     </Directory>
 </VirtualHost>

아파치를 재시작 합니다.
[root@ruo91 ~]# /usr/local/apache2/bin/apachectl restart

:
Posted by 비개인오후

티스토리툴바