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:
I suggest selecting the options BZ2, GD, MYSQLI, OPENSSL, PDF, ZLIB, MYCRYPT, ZIP
Now create a new Apache virtual host:
<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:
Note: this address is correct for phpMyAdmin 3.3.7, other versions, probably not...
This done, now remove the config dir:
Give phpMyAdmin database permissions:
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.