# Create and edit the configuration
vi /usr/local/www/data/phpMyAdmin/config.inc.php
<?php /* Servers configuration */ $i = 0; /* Server 172.28.0.70 */ $i++; $cfg['Servers'][$i]['host'] = '172.28.0.70'; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'mysql'; $cfg['Servers'][$i]['password'] = 'mysqlpassword'; /* End of servers configuration */ $cfg['UploadDir'] = 'uploads'; $cfg['ForceSSL'] = false; $cfg['ShowPhpInfo'] = true; $cfg['ShowChgPassword'] = true; $cfg['AllowArbitraryServer'] = true; $cfg['LoginCookieRecall'] = 'phpmyadmincookie'; $cfg['LoginCookieValidity'] = 1800; $cfg['blowfish_secret'] = 'blowfishpassword'; $cfg['SaveDir'] = 'exports'; $cfg['LeftFrameLight'] = true; $cfg['LeftFrameDBTree'] = true; $cfg['LeftFrameDBSeparator'] = '_'; $cfg['LeftFrameTableSeparator'] = '__'; $cfg['LeftFrameTableLevel'] = 1; $cfg['LeftDisplayLogo'] = true; $cfg['LeftDisplayServers'] = true; $cfg['DisplayServersList'] = true; $cfg['DisplayDatabasesList'] = 'auto'; $cfg['LeftPointerEnable'] = true; ?>

# Set directory permissions
chown -R www:www /usr/local/www/data/phpMyAdmin

# Edit httpd.conf to allow "main.php" as a default web page for a directory listing, add main.php to the end of this line:
vi /usr/local/etc/apache22/httpd.conf
DirectoryIndex index.html index.php

# Create an ".htaccess" file to permit only users you specify to access phpMyAdmin from the web
vi /usr/local/www/data/phpMyAdmin/.htaccess
AuthUserFile /etc/phpMyAdminhtpasswd.users AuthName "phpMyAdmin Access" AuthType Basic require valid-user

# Add the first user to create the password file:
/usr/local/sbin/htpasswd -c /etc/phpMyAdminhtpasswd.users admin

# Add more users if you want without creating a new file:
/usr/local/sbin/htpasswd /etc/phpMyAdminhtpasswd.users SomeOtherUserNameHere

# Edit the Apache configuration file  (Add to the very bottom of the file!)
vi /usr/local/etc/apache22/httpd.conf
# phpMyAdmin Alias /phpMyAdmin "/usr/local/www/data/phpMyAdmin" <Directory "/usr/local/www/data/phpMyAdmin"> AllowOverride AuthConfig Options ExecCGI Order allow,deny Allow from all </Directory>

# Update permissions
chown -R www:www /usr/local/www/data/