Install phpmyadmin di FreeBSD

Last Updated on Sunday, 19 August 2012 19:40 Written by Rudy Sunday, 19 August 2012 19:38

Attention: open in a new window. PDFPrintE-mail

 

 

phpmyadmin

Haiiyaaaaahhh…. matik lagi ftp.itb.ac.id nyah… :(
Lanjut besok lagi deh…

yak,lanjut-lanjuuuttt..

master# cd /usr/ports/databases/phpmyadmin
master# cd /usr/local/www/phpMyAdmin/
master# vim config.sample.inc.php

edit baris-baris didalamnya menjadi seperti ini

$cfg['blowfish_secret'] = ‘somethingsomething‘;
$cfg['Servers'][$i]['auth_type'] = ‘cookie’;
$cfg['Servers'][$i]['host'] = ‘localhost’;
$cfg['Servers'][$i]['connect_type'] = ‘socket‘;
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = ‘mysql’;

kemudian rename config.sample.inc.php menjadi config.inc.php
konfigur mysql database untuk opsi lebih lanjut

master# mysql -u root -p

dan jalankan perintah berikut dalam mysql

grant select, insert, update, delete on phpmyadmin.* to pma@localhost identified by ‘passwordpma‘;

keluar dari mysql dan buat database melalui skrip yang sudah disediakan oleh phpmyadmin

master# cd /usr/local/www/phpMyAdmin/scripts/
master# mysql -u root -p < create_tables.sql
master# mysql -u root -p < upgrade_tables_mysql_4_1_2+.sql

edit kembali file config.inc.php dan tambahkan baris-baris berikut

$cfg['Servers'][$i]['controluser'] = ‘pma‘;
$cfg['Servers'][$i]['controlpass'] = ‘passwordpma‘;
$cfg['Servers'][$i]['pmadb'] = ‘phpmyadmin’;
$cfg['Servers'][$i]['bookmarktable'] = ‘pma_bookmark’;
$cfg['Servers'][$i]['relation'] = ‘pma_relation’;
$cfg['Servers'][$i]['table_info'] = ‘pma_table_info’;
$cfg['Servers'][$i]['table_coords'] = ‘pma_table_coords’;
$cfg['Servers'][$i]['pdf_pages'] = ‘pma_pdf_pages’;
$cfg['Servers'][$i]['column_info'] = ‘pma_column_info’;
$cfg['Servers'][$i]['history'] = ‘pma_history’;

sekarang mari kita bikin file konfigurasi apache untuk menyediakan url akses phpmyadmin

master# vim /usr/local/etc/apache22/Includes/phpmyadmin.conf

isikan baris-baris berikut kedalam file tersebut

Alias /phpmyadmin “/usr/local/www/phpMyAdmin/”

Options none
AllowOverride All
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 167.205

ganti 167.205 sesuai dengan alamat network dari mana phpmyadmin bisa diakses
dan phpmyadmin bisa diakses dengan url /phpmyadmin misal :

http://167.205.34.104/phpmyadmin
http://localhost/phpmyadmin

selamat mencoba :D