PhpMyAdmin??????? - PowerPoint PPT Presentation

1 / 15
About This Presentation
Title:

PhpMyAdmin???????

Description:

PhpMyAdmin phpMyAdmin MySQL phpMyAdmin ... – PowerPoint PPT presentation

Number of Views:112
Avg rating:3.0/5.0
Slides: 16
Provided by: hin146
Category:
Tags: phpmyadmin | mysql | with

less

Transcript and Presenter's Notes

Title: PhpMyAdmin???????


1
PhpMyAdmin???????
  • ??????phpMyAdmin??????MySQL???,phpMyAdmin?????????
    ????????,????,???PHPMySQL?????,????????

2
1-1??MySQL????
  • ?????????,????MySQL????chai?????grant
    ?????,?????????322739aa??????????????phpMyAdmin???
    ??config.inc.php?

3
1-2??phpMyAdmin???????
  • ?????http//www.phpmyadmin.net/?????????????

4
  • ????????/var/www/html??phpMyAdmin-2..-php.tar.gz
    ????
  • tar -zxvf phpMyAdmin-2..-php.tar.gz
  • ???????????phpMyAdmin-2.5.1???,???????phpMyAdmin??
    ??
  • mv phpMyAdmin-2.5.1 phpMyAdmin

5
1-3??phpMyAdmin????
  • ??phpMyAdmin????config.inc.php,?????????????
  • vi config.inc.php
  • ??phpMyAdmin????????????,cfgPmaAbsoluteUri???
    ?????,???????????http//mandrake.aasir.com????????
    phpMyAdmin?
  • cfg'PmaAbsoluteUri' 'http//mandrake.aasir.co
    m/phpMyAdmin'
  • ????MySQL?????,?????MySQL??????mandrake.aasir.com?
    ???,???????????mandrake.aasir.com,??????localhost?
    ???????
  • cfg'Servers'i'host'
    'mandrake.aasir.com'
  • ??????MySQL???????chai,????????MySQL?????????chai?
    ???phpMyAdmin????????chai?
  • cfg'Servers'i'user' 'chai'
  • ??????MySQL???????chai,????????MySQL?????????chai?
    ???322739aa????phpMyAdmin????????chai???322739aa
    ?
  • cfg'Servers'i'password' '322739aa'

6
1-4?????
  • ??????????????,??????????,????????????????????????
    ???????????????mandrake.aasir.com???/phpMyAdmin/??
    ?,?????????????????,??????????????,?????????Apache
    ????
  • ???Apache????????????????????phpMyAdmin???
  • ???RedHat Linux Fadora 1???Apache?????
  • vi /etc/httpd/conf/httpd.conf
  • ????/var/www/html/phpMyAdmin?????phpMyAdmin??????
  • AuthName????/phpMyAdmin??????????????????????Aut
    hType??????????Basic?Basic????????????????????????
    ????AuthUserFile???????????????,??????????/home/ch
    aiyen/password.file?
  • Require??????????????????????,??????require user
    chaiyen?????chaiyen???????/var/www/html/phpMyAdmin
    ????
  • AuthAuthoritative????????,????????????,???????on??
    ?,???????????off????

7
  • ??????htpasswd????chaiyen???????password.file,????
    ??????/home/chaiyen????,????????????????,htpasswd?
    ???????????,?????????????htpasswd??-c?????????????
    ?????????????,???????????,???-c????????????????cha
    iyen?
  • htpasswd -c /home/chaiyen/password.file chaiyen

8
  • ??????Apache?????/home/chaiyen/password.file??????
    ????
  • chmod 644 /home/chaiyen/password.file
  • ??????Apache?????/var/www/html/phpMyAdmin?????????
    ????
  • chmod 755 /var/www/html/phpMyAdmin
  • ???????????????Apache??????
  • ?????http//mandrake.aasir.com/phpMyAdmin/?,??????
    ?????chaiyen????

9
  • ???????????????
  • ????????????????????????

10
  • ??????????????,??????phpMyAdmin???????

11
1-5??phpMyAdmin
  • ?????? phpMyAdmin??????????????????,??????????????
    ?
  • ??????Language???Chinese traditional(zh-tw)?

12
  • ??????MySQL??????????????????
  • ??????MySQL??????????????????

13
  • ??????????????????????????
  • ????????????????????,??????????MySQL???????

14
1-6?????
  • ??????????,????????????????,????????????????????
  • ?????????????,????????????,???????SQL???

15
  • ????SQL,???SQL??,?????,?????????????????????????
  • ???????,?????????????phpMyAdmin????PHP?????????,??
    ?????
Write a Comment
User Comments (0)
About PowerShow.com