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?????????,??
  ?????