iSpying foryou !: Epel

วิธีติดตั้ง phpMyAdmin บน CentOS 6.4

Step 1: Add EPEL Repository in System

ทำการดาวน์โหลดและติดตั้ง EPEL ที่ (เลือก 32,64)

// 32BIT
# wget http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

// 64BIT
# wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

Step 2: ติดตั้ง EPEL โดยใช้คำสั่ง rpm

# rpm -Uvh epel-release-6-8.noarch.rpm

Step 3: ติดตั้ง phpMyAdmin โดยใช้คำสั่ง um

# yum install phpMyAdmin

Output

Loaded plugins: fastestmirror, refresh-packagekit, security
Repository linuxtech-release is listed more than once in the configuration
Loading mirror speeds from cached hostfile
 * base: mirror.leapswitch.com
 * epel: mirrors.ispros.com.bd
 * extras: mirror.leapswitch.com
 * remi: mirror.smartmedia.net.id
 * updates: mirror.leapswitch.com
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:4.0.8-1.el6.remi will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================
 Package              Arch             Version                      Repository      Size
=========================================================================================
Installing:
 phpMyAdmin           noarch           4.0.8-1.el6.remi             remi           4.5 M

Transaction Summary
=========================================================================================
Install       1 Package(s)

Total download size: 4.5 M
Installed size: 22 M
Is this ok [y/N]: y
Downloading Packages:
phpMyAdmin-4.0.8-1.el6.remi.noarch.rpm                            | 4.5 MB     00:21
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : phpMyAdmin-4.0.8-1.el6.remi.noarch                                    1/1

Installed:
  phpMyAdmin.noarch 0:4.0.8-1.el6.remi

Complete!

Step 4: คอนฟิก phpMyAdmin เพื่อ Remote เข้ามาใช้งานผ่านเว็บบราวเซอร์

เข้าไป Config หมายเลข IP เพื่อให้เข้าถึง phpMyAdmin ได้จากภายนอก

#vi /etc/httpd/conf.d/phpMyAdmin.conf

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

<Directory /usr/share/phpMyAdmin/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     Require local
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 192.168.1.0/24 (เปลี่ยนเป็น IP ของคุณ)
     Allow from ::1
   </IfModule>
</Directory>