Database MySQL

Installing phpMyAdmin and connecting to remote database server

phpMyAdmin is one of the many tools that allows administrators the ability to effectively and efficiently work with their databases. This can can either be a local database or on a remote database. Where ever the location of your database, phpMyAdmin will easily allow you to connect to both.


Installing phpMyAdmin

This can be done either via FTP or directly from your command terminal.


Download the phpMyAdmin file which supports your version on MySQL. In this example, I will be using phpMyAdmin 4.4.12 which is the latest (at the time of this writing) and supports MySQL 5.5. This can be downloaded here. Once it has been downloaded it will need to be extracted and then uploaded to your server. Be sure to rename this as this will be the name that will be used when accessing via your web browser. In this case the default directory name was renamed phpMyAdmin-4.4.12-english to pma.

The final url path will be


Once logged into the server via ssh you can wget or fetch to download phpMyAdmin directly to your server. It can be downloaded using the following:




Extract Directory:

tar -xvf phpMyAdmin-4.4.12-all-languages.tar.gz phpMyAdmin-4.4.12-all-languages

Rename Directory:

mv phpMyAdmin-4.4.12-all-languages pma

The final url path will be

Configuring Remote Server Access:

Copy the phpMyAdmin sample configuration:



From: $cfg[‘Servers’][$i][‘host’] = ‘localhost';  // Default Settings, Local Database Server

To: $cfg[‘Servers’][$i][‘host’] = ‘';  // New Settings, Remote Database Server

To Conclude:

I hope this has provided some insight on how to install and configure phpMyAdmin in order to make your database administration life easier than it may have been before!


Related Articles


    What is a LAMP Stack? “LAMP stack is a popular open source web platform commonly used to run dynamic web sites and servers. It includes Linux, Apache, MySQL, and PHP/Python/Perl...
  • Monitoring MySQL

    Monitoring MySQL servers can be difficult in a way that a novice won’t be able to monitor MySQL that easily. MySQL gives a comprehensive list of variables to check your server’s health...
  • Reset MySQL Password

    Resetting a MySQL Root Password is one of the easiest things to do. However, finding documentation on how to do so can be challenging.   We as system administrators, have...
  • MySQL Basic fundamentals

    A Basic MySQL Tutorial    Introduction: MySQL MySQL is an open source database management software that helps users store, organize, and retrieve data. It is a very powerful program with...