Install PHPMyAdmin
aptitude install phpmyadmin
 
Move default phpmyadmin configuration to available site configuration for apache

mv /etc/apache2/conf.d/phpmyadmin.conf /etc/apache2/sites-available/phpmyadmin

Add port number in etc/apache2/ports.conf

nano /etc/apache2/ports.conf
Listen 8010

Add VirtualHost configuration to phpmyadmin

nano /etc/apache2/sites-available/phpmyadmin

And add the following lines at the end of the file:

<virtualhost :8010>
DocumentRoot /usr/share/phpmyadmin
ServerName dspace
<directory phpmyadmin=”” share=”” usr=””>
Options Indexes FollowSymLinks
DirectoryIndex index.php

<ifmodule mod_php5.c=””>
AddType application/x-httpd-php .php

php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_value include_path .
</ifmodule>

</directory>

# Authorize for setup
<directory phpmyadmin=”” setup=”” share=”” usr=””>
<ifmodule mod_authn_file.c=””>
AuthType Basic
AuthName “phpMyAdmin Setup”
AuthUserFile /etc/phpmyadmin/htpasswd.setup
</ifmodule>
Require valid-user
</directory>

# Disallow web access to directories that don’t need it
<directory libraries=”” phpmyadmin=”” share=”” usr=””>
Order Deny,Allow
Deny from All
</directory>
<directory lib=”” phpmyadmin=”” setup=”” share=”” usr=””>
Order Deny,Allow
Deny from All
</directory>
</virtualhost>

Enable edited site phpmyadmin.conf

a2ensite phpmyadmin
 
Restart Apache
 
/etc/init.d/apache2 restart 

Advertisements