Install dan Konfigurasi phpMyAdmin

Tutorial untuk install phpMyAdmin dari rpm dan mengkonfigurasi nya sehingga bisa di akses http://host/phpMyAdmin/

1.Install paket phpMyAdmin

[[email protected] ~]# yum install phpMyAdmin
Loaded plugins: fastestmirror
Repository epel is listed more than once in the configuration
Determining fastest mirrors
epel                                                      | 2.1 kB     00:00     
primary.sqlite.bz2                                        | 2.6 MB     00:27     
myindo                                                    |  951 B     00:00     
primary.xml.gz                                            | 3.4 kB     00:00     
myindo                                                         2/2
base                                                      | 1.1 kB     00:00     
primary.xml.gz                                            | 878 kB     00:13     
base                                                           2508/2508
updates                                                   |  951 B     00:00     
primary.xml.gz                                            | 185 kB     00:02     
updates                                                        287/287
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:2.11.9.5-1.el5 set to be updated
--> Processing Dependency: php-mysql >= 4.1.0 for package: phpMyAdmin
--> Processing Dependency: php >= 4.1.0 for package: phpMyAdmin
--> Processing Dependency: php-mbstring >= 4.1.0 for package: phpMyAdmin
--> Processing Dependency: webserver for package: phpMyAdmin
--> Running transaction check
---> Package php-mbstring.i386 0:5.1.6-23.2.el5_3 set to be updated
--> Processing Dependency: php-common = 5.1.6-23.2.el5_3 for package: php-mbstring
---> Package php-mysql.i386 0:5.1.6-23.2.el5_3 set to be updated
--> Processing Dependency: php-pdo for package: php-mysql
---> Package php.i386 0:5.1.6-23.2.el5_3 set to be updated
--> Processing Dependency: php-cli = 5.1.6-23.2.el5_3 for package: php
--> Processing Dependency: libcurl.so.3 for package: php
--> Processing Dependency: libaspell.so.15 for package: php
--> Processing Dependency: libgmp.so.3 for package: php
--> Processing Dependency: libidn.so.11 for package: php
--> Processing Dependency: libpspell.so.15 for package: php
---> Package httpd.i386 0:2.2.3-22.el5.centos.1 set to be updated
filelists.sqlite.bz2                                      | 4.0 MB     00:43     
filelists.xml.gz                                          | 1.4 kB     00:00     
filelists.xml.gz                                          | 2.8 MB     00:29     
filelists.xml.gz                                          | 1.3 MB     00:13     
--> Processing Dependency: libaprutil-1.so.0 for package: httpd
--> Processing Dependency: libapr-1.so.0 for package: httpd
--> Processing Dependency: /etc/mime.types for package: httpd
--> Running transaction check
---> Package libidn.i386 0:0.6.5-1.1 set to be updated
---> Package php-pdo.i386 0:5.1.6-23.2.el5_3 set to be updated
---> Package curl.i386 0:7.15.5-2.1.el5_3.4 set to be updated
---> Package apr-util.i386 0:1.2.7-7.el5_3.1 set to be updated
---> Package mailcap.noarch 0:2.1.23-1.fc6 set to be updated
---> Package php-cli.i386 0:5.1.6-23.2.el5_3 set to be updated
---> Package php-common.i386 0:5.1.6-23.2.el5_3 set to be updated
---> Package apr.i386 0:1.2.7-11 set to be updated
---> Package gmp.i386 0:4.1.4-10.el5 set to be updated
---> Package aspell.i386 12:0.60.3-7.1 set to be updated
--> Processing Dependency: aspell-en for package: aspell
--> Running transaction check
---> Package aspell-en.i386 50:6.0-2.1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================
 Package            Arch         Version                     Repository     Size
=================================================================================
Installing:
 phpMyAdmin         noarch       2.11.9.5-1.el5              epel          4.2 M
Installing for dependencies:
 apr                i386         1.2.7-11                    base          122 k
 apr-util           i386         1.2.7-7.el5_3.1             updates        76 k
 aspell             i386         12:0.60.3-7.1               base          936 k
 aspell-en          i386         50:6.0-2.1                  base          1.6 M
 curl               i386         7.15.5-2.1.el5_3.4          updates       232 k
 gmp                i386         4.1.4-10.el5                base          664 k
 httpd              i386         2.2.3-22.el5.centos.1       updates       1.2 M
 libidn             i386         0.6.5-1.1                   base          194 k
 mailcap            noarch       2.1.23-1.fc6                base           14 k
 php                i386         5.1.6-23.2.el5_3            updates       1.1 M
 php-cli            i386         5.1.6-23.2.el5_3            updates       2.1 M
 php-common         i386         5.1.6-23.2.el5_3            updates       151 k
 php-mbstring       i386         5.1.6-23.2.el5_3            updates       994 k
 php-mysql          i386         5.1.6-23.2.el5_3            updates        85 k
 php-pdo            i386         5.1.6-23.2.el5_3            updates        64 k

Transaction Summary
=================================================================================
Install     16 Package(s)         
Update       0 Package(s)         
Remove       0 Package(s)         

Total download size: 14 M
Is this ok [y/N]: y
Downloading Packages:
(1/16): mailcap-2.1.23-1.fc6.noarch.rpm                   |  14 kB     00:00     
(2/16): php-pdo-5.1.6-23.2.el5_3.i386.rpm                 |  64 kB     00:00     
(3/16): apr-util-1.2.7-7.el5_3.1.i386.rpm                 |  76 kB     00:00     
(4/16): php-mysql-5.1.6-23.2.el5_3.i386.rpm               |  85 kB     00:00     
(5/16): apr-1.2.7-11.i386.rpm                             | 122 kB     00:04     
(6/16): php-common-5.1.6-23.2.el5_3.i386.rpm              | 151 kB     00:01     
(7/16): libidn-0.6.5-1.1.i386.rpm                         | 194 kB     00:01     
(8/16): curl-7.15.5-2.1.el5_3.4.i386.rpm                  | 232 kB     00:02     
(9/16): gmp-4.1.4-10.el5.i386.rpm                         | 664 kB     00:09     
(10/16): aspell-0.60.3-7.1.i386.rpm                       | 936 kB     00:10     
(11/16): php-mbstring-5.1.6-23.2.el5_3.i386.rpm           | 994 kB     00:11     
(12/16): php-5.1.6-23.2.el5_3.i386.rpm                    | 1.1 MB     00:13     
(13/16): httpd-2.2.3-22.el5.centos.1.i386.rpm             | 1.2 MB     00:14     
(14/16): aspell-en-6.0-2.1.i386.rpm                       | 1.6 MB     00:16     
(15/16): php-cli-5.1.6-23.2.el5_3.i386.rpm                | 2.1 MB     00:29     
(16/16): phpMyAdmin-2.11.9.5-1.el5.noarch.rpm             | 4.2 MB     00:57     
---------------------------------------------------------------------------------
Total                                             78 kB/s |  14 MB     02:58     
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : mailcap                                         [ 1/16] 
  Installing     : php-common                                      [ 2/16] 
  Installing     : libidn                                          [ 3/16] 
  Installing     : curl                                            [ 4/16] 
  Installing     : apr                                             [ 5/16] 
  Installing     : gmp                                             [ 6/16] 
  Installing     : apr-util                                        [ 7/16] 
  Installing     : httpd                                           [ 8/16] 
  Installing     : php-mbstring                                    [ 9/16] 
  Installing     : php-pdo                                         [10/16] 
  Installing     : php-mysql                                       [11/16] 
  Installing     : aspell-en                                       [12/16] 
  Installing     : aspell                                          [13/16] 
  Installing     : php-cli                                         [14/16] 
  Installing     : php                                             [15/16] 
  Installing     : phpMyAdmin                                      [16/16] 

Installed: phpMyAdmin.noarch 0:2.11.9.5-1.el5
Dependency Installed: apr.i386 0:1.2.7-11 apr-util.i386 0:1.2.7-7.el5_3.1 aspell.i386 12:0.60.3-7.1 aspell-en.i386 50:6.0-2.1 curl.i386 0:7.15.5-2.1.el5_3.4 gmp.i386 0:4.1.4-10.el5 httpd.i386 0:2.2.3-22.el5.centos.1 libidn.i386 0:0.6.5-1.1 mailcap.noarch 0:2.1.23-1.fc6 php.i386 0:5.1.6-23.2.el5_3 php-cli.i386 0:5.1.6-23.2.el5_3 php-common.i386 0:5.1.6-23.2.el5_3 php-mbstring.i386 0:5.1.6-23.2.el5_3 php-mysql.i386 0:5.1.6-23.2.el5_3 php-pdo.i386 0:5.1.6-23.2.el5_3
Complete!
[[email protected] ~]# 


diatas sebenarnya banyak yang harusnya gak ikut keinstall apabila sudah ke install, misalnya httpd
setelah itu jangan lupa install php-mcrypt

[[email protected] ~]# yum install php-mcrypt
Loaded plugins: fastestmirror
Repository epel is listed more than once in the configuration
Loading mirror speeds from cached hostfile
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package php-mcrypt.i386 0:5.1.6-5.el5 set to be updated
--> Processing Dependency: libmcrypt.so.4 for package: php-mcrypt
--> Running transaction check
---> Package libmcrypt.i386 0:2.5.7-5.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================
 Package              Arch           Version                Repository      Size
=================================================================================
Installing:
 php-mcrypt           i386           5.1.6-5.el5            epel            16 k
Installing for dependencies:
 libmcrypt            i386           2.5.7-5.el5            epel           124 k

Transaction Summary
=================================================================================
Install      2 Package(s)         
Update       0 Package(s)         
Remove       0 Package(s)         

Total download size: 140 k
Is this ok [y/N]: y
Downloading Packages:
(1/2): php-mcrypt-5.1.6-5.el5.i386.rpm                    |  16 kB     00:00     
(2/2): libmcrypt-2.5.7-5.el5.i386.rpm                     | 124 kB     00:01     
---------------------------------------------------------------------------------
Total                                             62 kB/s | 140 kB     00:02     
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : libmcrypt                                         [1/2] 
  Installing     : php-mcrypt                                        [2/2] 

Installed: php-mcrypt.i386 0:5.1.6-5.el5
Dependency Installed: libmcrypt.i386 0:2.5.7-5.el5
Complete!
[[email protected] ~]# 


2.Konfigurasi phpMyAdmin
Lakukan edit file /etc/httpd/conf.d/phpMyAdmin.conf
dari :

# phpMyAdmin - Web based MySQL browser written in php
# 
# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

   order deny,allow
   deny from all
   allow from 127.0.0.1


# This directory does not require access over HTTP - taken from the original
# phpMyAdmin upstream tarball
#

    Order Deny,Allow
    Deny from All
    Allow from None


# This configuration prevents mod_security at phpMyAdmin directories from
# filtering SQL etc.  This may break your mod_security implementation.
#
#
#    
#        SecRuleInheritance Off
#    
#


Menjadi

[[email protected] ~]# cat /etc/httpd/conf.d/phpMyAdmin.conf 
# phpMyAdmin - Web based MySQL browser written in php
# 
# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

   order deny,allow
   #deny from all
   #allow from 127.0.0.1


# This directory does not require access over HTTP - taken from the original
# phpMyAdmin upstream tarball
#

    Order Deny,Allow
    Deny from All
    Allow from None


# This configuration prevents mod_security at phpMyAdmin directories from
# filtering SQL etc.  This may break your mod_security implementation.
#
#
#    
#        SecRuleInheritance Off
#    
#
[[email protected] ~]# 


disini saya hanya ngedit bagian
#deny from all
#allow from 127.0.0.1

artinya diallowed dari semua ip, untuk allowed dari ip tertentu, misalnya ip 202.xxx.xxx.10 maka menjadi
deny from all
allow from 202.xxx.xxx.10

setelah itu restart httpd

[[email protected] ~]# /etc/init.d/httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]
[[email protected] ~]# 


setelah itu setting phpMyAdmin.conf di /etc/phpMyAdmin/config.inc.php
dibawah $i = 0 tambahkan $cfg[‘blowfish_secret’] = ‘H1PvIjBDbw’; sehingga menjadi :
$i = 0;
$cfg['blowfish_secret'] = 'H1PvIjBDbw';

terus rubah
$cfg['Servers'][$i]['auth_type'] = 'http';
menjadi :
$cfg['Servers'][$i]['auth_type'] = 'cookie';
setelah itu save
setelah itu tinggal http://host/phpMyAdmin

3 thoughts on “Install dan Konfigurasi phpMyAdmin

Leave a Reply

Your email address will not be published. Required fields are marked *