Revision of phpMyAdmin from Tue, 12/15/2009 - 15:31

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://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-3.1.5-english.tar.gz
tar zxf phpMyAdmin-3.1.5-english.tar.gz
rm phpMyAdmin-3.1.5-english.tar.gz

Move the phpmyadmin source files into the base directory:

mv phpMyAdmin-3.1.5-english phpmyadmin
chown -R nobody:nobody phpmyadmin

Configuration
phpMyAdmin 3.1.5 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

  • nginx
    1 year 1 month ago
    1.27.2 update
  • lighttpd
    1 year 1 month ago
    Drupal 10/11 config
  • Drupal 11
    1 year 1 month ago
  • PHP
    1 year 1 month ago
    PHP 8.3.11 and AlmaLinux
  • Pound SSL Proxy
    1 year 1 month ago
    New version of Pound
Error | Production Monkeys

Error

The website encountered an unexpected error. Please try again later.