Bobby's Blog

How to Manually Install phpMyAdmin and Link it to an External Server

mysql-phpmyadmin-install-manual

Sometimes you might need to install a second instance of phpMyAdmin and link it with an external server for example.

Here’s an easy way on how to do that.

1. Prepare the phpMyAdmin files:

– Download phpMyAdmin in the desired directory:

– Unzip the archive:

– Rename the folder:

– Access the folder:

2. The phpMyAdmin configuration part:

– Edit the config file to update the database host:

– Then update the following line to the correct database host:

– Then rename the config to:

3. First create VHost, I would use a simple one like:

4. Test syntax:

If you get syntax on restart:

Make sure that the VHost is working!

5. Important! To be on the safe side test the installation and also add a basic 401 auth:

– Create an .htaccess file in the phpMyAdmin directory and add:

– Create valid user user:

This is pretty much it, you might have some issues with the DB permissions but it is a different story.


About the author

Bobby

Linux System Administrator