contact :: legal :: webstats  also on this site: - select - home tech writings green business studies conspiracy popular pages welcome  also in this section:  tech index  most popular pages  search: Like this site? Your donation is welcome!

phpMyAdmin allows point-and-click management of MySQL databases. It's very useful, although knowing how to do the same thing with the commandline is sometimes invaluable.

Note: these instructions assume you are using Virtual Hosts in httpd.conf. They will vary slightly if used in a different configuration, such as with an alias.

Note: Ensure to install Apache and MySQL before installing phpMyAdmin.

To install phpMyAdmin:

1. cd /usr/ports/databases/phpmyadmin
2. make install clean

   I suggest selecting the options BZ2, GD, MYSQLI, OPENSSL, PDF, ZLIB, MYCRYPT, ZIP

Now create a new Apache virtual host:

1. vi /usr/local/etc/apache/httpd.conf
2. scroll to the end and insert syntax similar to the following:

   <VirtualHost *>
   ServerName phpmyadmin.domainname.com
   DocumentRoot /usr/local/www/phpMyAdmin/
   CustomLog /usr/local/www/logs/phpmyadmin-access.log combined
   ErrorLog /usr/local/www/logs/phpmyadmin-error.log
   </VirtualHost>
   <Directory "/usr/local/www/phpMyAdmin">
       Options Indexes FollowSymLinks MultiViews
       AllowOverride FileInfo Limit Options
       Order allow,deny
       Allow from all
   </Directory>
   

Create config directory and allocate permissions:

1. mkdir /usr/local/www/phpMyAdmin/config
2. chmod 777 /usr/local/www/phpMyAdmin/config

Restart Apache:

1. /usr/local/sbin/apachectl restart

Configure phpmyadmin:

1. In a web browser, access http://phpmyadmin.domainname.com/setup

   Note: this address is correct for phpMyAdmin 3.3.7, other versions, probably not...

2. click New Server button
3. set authentication type to HTTP
4. ensure "User for config auth" is blank
5. click Save button

This done, now remove the config dir:

1. rm -rf /usr/local/www/phpMyAdmin/config

Give phpMyAdmin database permissions:

1. mysql -uroot -pROOT_PASSWORD -e"GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'ROOT_PASSWORD'"

As the server will likely have no DNS entry, to resolve it, add an entry to your HOSTS file. Do not use the server's IP in your browser's address bar - Apache will not know that you intend to access the phpMyAdmin virtual host, and will display the default website.

Notes:

• Watch out for the capitalisation on the phpMyAdmin directory name!

related articles:  my FreeBSD diary  FreeBSD and ATA disks  adding a disk  upgrading a disk  FreeBSD backups  backing up to a remote volume  Samba as a file server (low security)  Samba as a file server (high security)  Samba as a Primary Domain Controller  Samba as a member server  Samba as a print server (with CUPS)  troubleshooting Samba  troubleshooting printing with CUPS  configuring sendmail  installing phpMyAdmin  dealing with mail for root  working with cron  installing and using GPG  automated PHP scripting  special-purpose users  upgrading to key-based authentication  distributed data warehousing  doing a minor version upgrade  upgrading from 6.1 to 6.4  upgrading 6.2 and below  installing and using Webmin  installing and using denyhosts  filesystem access controls  unix basics