Revision of phpMyAdmin from Wed, 12/16/2009 - 13:30

Revisions allow you to track differences between multiple versions of your content, and revert back to older versions.

phpMyAdmin is a browser-based utility for managing MySQL databases.

Apache Configuration
Create a base directory for the your private, local site:

mkdir -p /var/websites/private/logs/
mkdir -p /var/websites/private/htdocs

Edit /usr/local/apache2/conf/httpd.conf and add a non-standard port for it to listen on (maximum allowed is 65535):

Listen 12345

Edit /usr/local/apache2/conf/extra/httpd-vhosts.conf and add a virtual host directive:

<VirtualHost _default_:12345>
  DocumentRoot /var/websites/private/htdocs

  <Directory /var/websites/private/htdocs>
    Options Indexes FollowSymLinks
    AllowOverride All
    Order allow,deny
    Allow from all
  </Directory>

  ErrorLog /var/websites/private/logs/private-error_log
  CustomLog /var/websites/private/logs/private-access_log combined
</VirtualHost>

Installation
Download the source tarball:

cd /var/websites/private/htdocs
wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.2.4/phpMyAdmin-3.2.4-all-languages.tar.gz?use_mirror=softlayer
tar zxf phpMyAdmin-3.2.4-all-languages.tar.gz
rm phpMyAdmin-3.2.4-all-languages.tar.gz

Move the phpmyadmin source files into the base directory:

mv phpMyAdmin-3.2.4-all-languages phpmyadmin
chown -R nobody:nobody phpmyadmin

Configuration
phpMyAdmin 3.2.4 didn't need to be configured like previous versions. Not sure exactly, but it appears that it has some default settings or something that allow it to access the MySQL server on the localhost without any extra configuration. However, to access remote MySQL servers, you probably need to do it.

In order to use the config script, we'll need to set up a conf directory:

cd /var/websites/private/htdocs/phpmyadmin
mkdir config
chown nobody:nobody config
chmod o+rw config

Access the setup script at http://<myserver>:12345/phpmyadmin/setup

Once the config file has been saved, move it to the proper location:

cd /var/websites/private/htdocs/phpmyadmin
mv config/config.inc.php .
chmod o-rw config.inc.php

Multiple Servers
on the same machine

Recent Updates

  • Apache
    2 years 1 week ago
  • Apache
    2 years 1 week ago
  • lighttpd
    2 years 1 week ago
    php 8.x
  • MariaDB
    2 years 1 week ago
    10.6.7
  • CentOS
    2 years 2 weeks ago
    Drop Centos 5/6 stuff