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:

1.

[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
</Directory>

7. edit file config.default.php

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

8.

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

http://localhost/phpmyadmin/

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

thanks

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:

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

%d bloggers like this: