Install dan Configurasi phpMyAdmin untuk MySQL Database

phpMyAdmin adalah client database berguna untuk memudahkan admin database membuat, mengubah dan merawat database Server dengan tampilan GUI, untuk phpMyAdmin ini dalam bentuk webbase jadi bisa diakses dari manapun.

1. Langkah Pertama Mendownload aplikasi melalui repository

$ cd /tmp
$ wget http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm
# rpm -ivh epel-release-6-5.noarch.rpm

2. Menginstall aplikasi phpMyAdmin

# yum search phpmyadmin
# yum -y install phpmyadmin

akan muncul script seperti di bawah :

Loaded plugins: rhnplugin
Setting up Install Process
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction first to finish them.
--> Running transaction check
---> Package phpMyAdmin.noarch 0:3.5.1-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
==================================================================================================
 Package                  Arch                 Version                   Repository          Size
==================================================================================================
Installing:
 phpMyAdmin               noarch               3.5.1-1.el6               epel               4.2 M
Transaction Summary
==================================================================================================
Install       1 Package(s)
Total download size: 4.2 M
Installed size: 17 M
Downloading Packages:
phpMyAdmin-3.5.1-1.el6.noarch.rpm                                          | 4.2 MB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : phpMyAdmin-3.5.1-1.el6.noarch                                                  1/1
  Verifying  : phpMyAdmin-3.5.1-1.el6.noarch                                                  1/1
Installed:
  phpMyAdmin.noarch 0:3.5.1-1.el6

3. Configurasi simpel phpMyAdmin

Rubah konfigurasi standar aplikasi seperti di bawah ini :

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

secara standar aplikasi ini hanya bisa di jalankan dari localhost saja, tidak bisa dari luar komputer demi keamanan, tambah ini :

Allow from ip_address

isi ip_address dengan ip yang boleh mengakses aplikasi ini.

jalankan phpMyAdmin dengan script di bawah ini :

# service httpd restart

4. Mencoba phpMyAdmin

Setelah semua selesai sekarang yang terakhir kita coba menjalankan aplikasi phpMyAdmin malalui browser dengan script :

http://your-server-ip/phpMyAdmin/

akan muncul form login, masukan user dan password mysql anda.
Screenshot from 2013-11-20 10:37:41setelah login akan muncul form ini.

phpMyAdmin-3.5.1-screenshot

Terimakasih
Efran Karunia
https://efrankarunia.wordpress.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s