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

  • How can I convert my MyISAM tables to InnoDB?

    If you want to convert a MyISAM table to InnoDB, the process is fairly easy, but you can do something extra to speed things up. Before converting the table, adjust...
  • Purpose of A Database

      Many beginners wonder to themselves: What do we use a database for? How is it beneficial to us? Why do we use a database? A DATABASE can be useful such...
  • 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...
  • 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...