Install PhpMyadmin in Apache webserver on FreeBSD

Sunday 10.13 pm after ate friedrice..nyummy..

this time i want to share how to install phpmyadmin. i use freebsd operating sytem 7.2 version. phpmyadmin is one of tools that handles mysql administration to quickly and easy. look at the picture below :

we can create database, privileges setting, DDL,and DML easier. OK…this time going to install phpmyadmin. Firstly make sure that mysql server is installed correctly.

[root@motte89 /usr/home/motte89]# pkg_info|grep mysql
mysql-client-5.0.77_1 Multithreaded SQL database (client)
mysql-server-5.0.77_1 Multithreaded SQL database (server)
php5-mysql-5.2.9    The mysql shared extension for php
php5-mysqli-5.2.9   The mysqli shared extension for php

if you sure now we just installed phpmyadmin . we will install from freebsd ports:


[root@motte89 /usr/home/motte89]# cd /usr/ports/databases/phpmyadmin
[root@motte89 /usr/ports/databases/phpmyadmin]# make install


2. choose config that you like

3. wait until installation finished

4. after instalation phpmyadmin will be installed in folder /usr/local/www/phpmyadmin

5. open httpd.conf

[root@motte89 /usr/local/www/phpMyAdmin]# ee /usr/local/etc/apache22/httpd.conf

6. create alias for phpmyadmin in httpd.conf

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

<Directory “/usr/local/www/phpMyAdmin/”>
Options none
AllowOverride Limit
Order allow,deny
Allow from all

7. edit file config.default.php

[root@motte89 /usr/local/www/phpMyAdmin]# ee /usr/local/www/phpMyAdmin/libraries/config.default.php


On entry $ cfg [‘Servers’] [$ i] [‘auth_type’] = ‘config’;

change it to:
$ Cfg [‘Servers’] [$ i] [‘auth_type’] = ‘http’;

Empty entry $ cfg [‘Servers’] [$ i] [‘user’] = ‘root’;

thus becomes:
$ Cfg [‘Servers’] [$ i] [‘ user ‘] =”;

9. then open in web browser


10. then insert your username and password for mysql server.



About 3wahyua

Islam is my way

Posted on October 10, 2010, in FreeBSD. Bookmark the permalink. Leave a comment.

Leave a Reply

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

You are commenting using your 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

%d bloggers like this: